Recap of April 2010 DMV a Day Series

Well, I managed to finish up my series that featured a DMV query every day during the month of April. I appreciate all of the comments and feedback I received. One suggestion I got from several readers was to recap the series in a single post at the end, which is what I am going to do here.

I also wanted to give a shout-out to fellow SQL MVP Paul Randal (blog | twitter), who also slogged through April with his own A SQL Server DBA Myth a Day series. Paul, who besides being Kimberly Tripp’s husband, is also an active and well-respected member of the SQL Server community squashed a lot of persistent myths during the course of the month.

Below is a simple listing of each post in the series, along with a hyperlink to the original blog post.  I have also listed the DMV for that day, along with a hyperlink to the online SQL Server 2008 BOL entry for that DMV.

A DMV a Day – Day 1    sys.dm_os_buffer_descriptors

A DMV a Day – Day 2    sys.dm_exec_sessions

A DMV a Day – Day 3    sys.dm_os_sys_info

A DMV a Day – Day 4    sys.dm_os_sys_memory

A DMV a Day – Day 5    sys.dm_db_mirroring_auto_page_repair

A DMV a Day – Day 6    sys.dm_db_index_usage_stats

A DMV a Day – Day 7    sys.dm_db_missing_index_group_stats

A DMV a Day – Day 8    sys.dm_fts_active_catalogs

A DMV a Day – Day 9    sys.dm_os_schedulers

A DMV a Day – Day 10   sys.dm_exec_procedure_stats

A DMV a Day – Day 11   sys.dm_db_index_usage_stats

A DMV a Day – Day 12   sys.dm_db_partition_stats

A DMV a Day – Day 13   sys.dm_io_virtual_file_stats

A DMV a Day – Day 14   sys.dm_os_wait_stats

A DMV a Day – Day 15   sys.dm_os_performance_counters

A DMV a Day – Day 16   sys.dm_exec_cached_plans

A DMV a Day – Day 17   sys.dm_db_index_usage_stats

A DMV a Day – Day 18   sys.dm_clr_tasks

A DMV a Day – Day 19   sys.dm_os_wait_stats

A DMV a Day – Day 20   sys.dm_exec_cached_plans

A DMV a Day – Day 21   sys.dm_os_ring_buffers

A DMV a Day – Day 22   sys.dm_exec_query_memory_grants

A DMV a Day – Day 23   sys.dm_os_process_memory

A DMV a Day – Day 24   sys.dm_exec_requests

A DMV a Day – Day 25   sys.dm_os_memory_cache_counters

A DMV a Day – Day 26   sys.dm_exec_procedure_stats

A DMV a Day – Day 27   sys.dm_tran_locks

A DMV a Day – Day 28   sys.dm_io_pending_io_requests

A DMV a Day – Day 29   sys.dm_exec_connections

A DMV a Day – Day 30   sys.dm_os_buffer_descriptors

As I suspected, I did end up using some of the DMVs more than once, but I have a different query that uses the repeated DMV on the days where that happened.

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

9 Responses to Recap of April 2010 DMV a Day Series

  1. Jeremy says:

    Glenn,Thank you for this great series. I am sure it took alot of time and energy to keep up with every day. We all greatly appreciate your effort and the information shared!-Jeremy

  2. Fabrício says:

    Great series!!! A book???

  3. Unknown says:

    Thanks for all your work and ESPECIALLY for the summary with links.

  4. Unknown says:

    BTW, when I "steal" code for my library I try to give credit where credit is due. It could work it\’s way into something I blog. Is a link to your blog sufficient?

  5. Glenn says:

    Sure, a link is sufficient. Thanks!

  6. Pingback: March Madness - SQL Server System Tables - syslogins | SQLRockstar

  7. Pingback: A SQL Server Hardware Nugget A Day – Series Recap | Glenn Berry's SQL Server Performance

  8. Pingback: Looking into new and enhanced DMVs and DMFs « DOT NET RULES

  9. Pingback: An XEvent A Day: 31 days of Extended Events | Jonathan Kehayias

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