PASS DBA Virtual Chapter Live Meeting Event

PASS DBA Virtual Chapter Live Meeting Event

Sharing this for those following for WSSUG (Wichita SQL Server User Group) updates. This was shared with me by PASS’ Virtual Chapter and sounded interesting, so I’m passing it along (no pun intended).

DBA Virtual Chapter Live Meeting Event
Wednesday, December 8th


Dr. DMV: How to Use Dynamic Management Views to Monitor and Diagnose Performance Issues With High Volume OLTP Workloads


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 R2 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 is applicable to both 2005, 2008 and 2008 R2), presents and explains over thirty DMV queries that you can quickly and easily use to detect and diagnose performance issues in your environment.

Meeting link: