tigertoolbox/Troubleshooting-Notebooks

SQL Server Troubleshooting Notebooks

Looking for guidance on troubleshooting common SQL Server issues? Look no further! In this folder you will find various notebooks that you can use in Azure Data Studio to guide you through the steps necessary to troubleshoot and resolve some of the most common issues in SQL Server.

Big Data Clusters - The troubleshooting guides for Big Data Clusters can be found here.

BPCheck.ipynb - This notebook checks SQL Server in scope for some of most common skewed Best Practices and performance issues. More details about BPCheck can be found here.

whatsup_diagnostic_queries.ipynb - This notebook contains a set of diagnostic queries that helps understand what's up with your SQL Server/Azure SQL Database and get all sorts of useful troubleshooting information such as: a snapshot on running sessions/requests, current blocking information, etc. More information about the Whats Up diagnostic queries can be found here.

DOCs-to-Notebooks - this set of notebooks is currently intended as a proof-of-concept to build Notebooks from troubleshooting SQL Server DOCs on https://docs.microsoft.com/sql/sql-server