SQL Server Diagnostic Queries – Part 11


I have recently started making videos for my YouTube channel. There are several different playlists, but the one for SQL Server is probably most relevant. Currently, I am working on a series of videos that dive pretty deeply into each of the queries in my SQL Server 2019 Diagnostic Information Queries. This post coincides with the SQL Server Diagnostic Queries – Part 11 video.

SQL Server Diagnostic Queries – Part 11

This particular video is the eleventh in a series of videos that will go through each of the queries in my SQL Server 2019 Diagnostic Information Queries, explaining what each query does and how to interpret the results of each query.

In this video, I cover Query 27 – Drive Level Latency, Query 28 – IO Latency by File, and Query 28, which is IO Warnings. These queries let you see how your storage subsystem has been performing from SQL Server’s perspective. The information you gather from these queries is very useful when you talk to your storage administrator.

My Diagnostic queries are available for free here.

Note: There are separate versions of these queries for every major version of SQL Server starting with SQL Server 2005. The general concepts in these videos are applicable to all versions of SQL Server, Azure SQL Database, and SQL Managed Instance.

Even if you are on an older version of SQL Server, these videos will be useful and interesting for you.

Final Words

If you have any questions about this post, please ask me here in the comments, in the YouTube comments for the video, or on Twitter. I am pretty active on Twitter as GlennAlanBerry. Thanks for reading!

Categories DMV Queries, SQL Server Diagnostic Information Queries, YouTube VideosTags

2 thoughts on “SQL Server Diagnostic Queries – Part 11

  1. Generally I try not to clutter the ether but in this case I just had to say “Thank you!” for the work you’ve done for the SQL Server community over the years. I’ve used (and learned from) your “Diagnostic Queries” since I was a pup. As my grandmother used to say, “Thanks ’til your better paid”.

    1. Thanks for your kind words. I appreciate it!

Please tell me what you think

%d bloggers like this:
search previous next tag category expand menu location phone mail time cart zoom edit close