Dr. DMV's Troubleshooting Toolkit - Glenn Berry - RSUG Meeting January 2023
Details
#### Description
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, and 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 to avoid performance and scalability issues.
#### Notes and comments
This is the SQL Server 2022 version of the script, which covers quite a bit of new queries for SQL Server 2022.
Agenda:
5:30 PM - 5:45 PM Networking & User Group updates
5:45 PM - 6:00 PM Sponsor Spotlight & Speaker Introduction
6:00 PM - 7:00 PM Featured presentation
7:00 PM - 7:30 PM Q&A and continued networking
We'd love to keep in touch! Visit https://www.redmondsql.org/membership-registration/ to join our user group to get access to free learning content.
Looking for the presentation from a previous monthly meeting? Visit our meeting archive: https://www.redmondsql.org/archives/.
Cheers,
Redmond SQL User Group Leadership Team
https://www.redmondsql.org