Speaking At Denver SQL Server User’s Group On May 21

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.

This entry was posted in SQL Server 2008. Bookmark the permalink.

3 Responses to Speaking At Denver SQL Server User’s Group On May 21

  1. T8tube.com says:


  2. ROdrigo says:

    Hello, is the demo on using the DMV script for diagnosing performance issues on 2005 available for dl?

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s