Blog Post

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.

Rate

You rated this post out of 5. Change rating

Share

Share

Rate

You rated this post out of 5. Change rating