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
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.