Presenting to the PASS Database Administration Virtual Chapter

I will be giving a presentation and demo to the PASS Database Administration Virtual Chapter on Wednesday, December 8 2010 at Noon, Mountain Time. I will be giving my Dr. DMV presentation, and here is the abstract:

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.

This will have the December 2010 version of my SQL Server 2008 Diagnostic Information Queries, which have quite a few changes and improvements compared to previous versions. The meeting will be on Windows LiveMeeting, and it will be recorded. I hope to see you there!

This entry was posted in PASS, Teaching and tagged , . Bookmark the permalink.

3 Responses to Presenting to the PASS Database Administration Virtual Chapter

  1. dmmaxwell says:

    Thank you for your presentation. It was very well done. Your queries have solved a few performance problems for me on many an occasion. So much so, I include them as part of my standard SQL installations now. With credit to you, of course.🙂

    Keep up the excellent work.
    -David.

  2. Amanda says:

    I saw your presentation as well, it was excellent!
    I’m wondering if there is any way to easily obtain information regarding the DOP of queries other than actually searching through the plans in cache. I see that there are a few views which contain references to DOP and maxdop (sys.dm_exec_query_optimizer_info and sys.dm_exec_query_memory_grants) but I am unsure how to interpret the results and the memory grants query contains only queries currently waiting on memory, from what I can see.

    Is there anything that will allow me to see the text of a query and it’s avg or last DOP? What about for 2005?
    Thanks!

  3. Glenn Berry says:

    Thanks! I am glad they were useful for you.

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 )

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s