I recently published a new video called Dr DMV for SQL Server 2019. In the video, I go through the complete set of my SQL Server 2019 Diagnostic Information Queries. First, I talk about what each query is designed to show. Next, I run the query, and finally I talk about how to interpret the results.
Dynamic Management Views (DMVs) and functions allow you to easily see exactly what is happening inside your SQL Server instances and databases with a high level of detail. You can discover your top wait types, most CPU intensive stored procedures, find missing indexes, and identify unused indexes, to name just a few examples.
This video presents, demonstrates and explains a complete set of diagnostic DMV queries that you can easily use to detect and diagnose configuration and performance issues in your SQL Server instances and databases.
This video goes into exhaustive detail on how to interpret the results of each of the diagnostic queries, including relevant background information on how to properly configure your hardware, storage subsystem, operating system, SQL Server instance and databases in order to avoid performance and scalability issues.
The information in this video is also relevant to older versions of SQL Server, and I have separate versions of these queries for every major version of SQL Server from SQL Server 2005 through SQL Server 2019.
Dr DMV for SQL Server 2019
You can download the queries used in this video here.
Here is the video:
I hope the video is useful for you, and I would love hear any feedback you might have!
If you have any thoughts or questions about this post, please ask me here in the comments or on Twitter. You can also follow me on Twitter, where I am @GlennAlanBerry. Thank you for reading!