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 13 video.
SQL Server Diagnostic Queries – Part 13
This particular video is the thirteenth 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, we are going to cover just one query, but it is a very useful one! This will be Query 32 – Missing Indexes All Databases.
At a high level, this query simply shows you missing index information for every database on the current instance. It is ordered by index advantage, which is a calculated column that is a rough measure of how valuable a possible new index might be for your workload.
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 interesting and useful for you.
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!