http://www.sqlservercentral.com/blogs/glennberry/2010/05/03/recap-of-april-2010-dmv-a-day-series/

Printed 2014/10/02 03:48AM

Recap of April 2010 DMV a Day Series

By GlennBerry, 2010/05/03

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.


Copyright © 2002-2014 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.