I’ll be presenting Dr. DMV’s Troubleshooting Toolkit at SQLSaturday Denver on October 12, 2019. This free event will be held at University of Denver – Sturm Hall, 2040 S Race St, Denver, Colorado, 80210. My session is at 10:15AM.
I always enjoy presenting at SQLSaturday events, and meeting new people, many of which have never been to a SQLSaturday event before.
Here is the abstract of the session:
Dr. DMV’s Troubleshooting Toolkit
Dynamic Management views 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 session 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 session 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.
In plain terms, I’ll be going through my SQL Server 2019 Diagnostic Information Queries, explaining what they mean, and how to interpret the results. This is always a lot of fun, and people seem to enjoy it. I hope I see you there!