SQL Server Diagnostic Query Reorganization

After much thought, and some procrastination, I have decided to implement a fairly significant reorganization of my SQL Server Diagnostic Information Queries, starting with the SQL Server 2016 version for January 2016. I use these queries on a daily basis during my consulting work at SQLskills.com, and I have been planning on making some changes to make them easier for me to use and analyze.

The main thrust of this reorganization effort to to change the order of the queries so that they are grouped more logically, making the results easier to comprehend and analyze. The general ordering is shown below:

  1. Instance-level information
    1. SQL Server configuration details
    2. OS configuration information
    3. Hardware details
    4. Storage details and performance information
    5. Database properties for all databases
    6. Instance-level performance information
  2. Specific database information
    1. File information and usage
    2. Query information
    3. Stored procedure information
    4. Index information
    5. Other performance information

In addition to this, I have revised and improved several of the queries so that they retrieve even more relevant information than before. I am continuing to add additional comments on how to interpret the results, along with additional links to useful sources of additional information about specific queries.

Finally, I have removed a number of queries that I have found to be less useful, taking the overall query count from 76 down to 69 for the SQL Server 2016 version. This will reduce the time required to run the queries and analyze the results.

Here are links to the current version of these queries for SQL Server 2016:

SQL Server 2016 Diagnostic Information Queries (January 2016)

SQL Server 2016 Blank Results

I am also planning on making some formatting changes in some of the queries, so that they work better with Excel.

I am going to make a similar reorganization effort for the SQL Server 2014 and SQL Server 2012 versions of these queries over the next couple of days. I will also make some minor updates to the SQL Server 2008 R2, SQL Server 2008, and SQL Server 2005 versions of the queries for the January release.

Please let me know what you think of these reorganized queries, and whether you have any suggestions for improvements. Thanks!

Leave a Reply

Your email address will not be published. Required fields are marked *

Other articles

Imagine feeling confident enough to handle whatever your database throws at you.

With training and consulting from SQLskills, you’ll be able to solve big problems, elevate your team’s capacity, and take control of your data career.