I will be giving a short presentation and demo at the Denver SQL Server User’s Group meeting on May 21. The group meets at the Microsoft office in the Denver Tech Center. Here is the title and abstract for my session.
Dr. DMV – Using DMV Queries to Detect and Diagnose Performance Issues in a High-volume OLTP Environment
SQL Server 2005 introduced Dynamic Management Views (DMVs) that allow you to see exactly what is happening inside your SQL Server instances and databases with much more detail than ever before. SQL Server 2008 adds even more capability in this area. 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 (which applicable to both 2005 and 2008), presents and explains over fifteen DMV queries that you can quickly and easily use to detect and diagnose performance issues in your environment.
I am just the “opening act” for SQL MVP Paul Nielsen, who will be giving the longer presentation on Advanced Data Modeling. I am also donating an MSDN Premium Subscription for the raffle at the end of the meeting.