A DMV a day
by Glen Berry Day 1 sys.dm_os_buffer_descriptorsDay 2 sys.dm_exec_sessionsDay 3 sys.dm_os_sys_infoDay 4 sys.dm_os_sys_memoryDay 5 sys.dm_db_mirroring_auto_page_repairDay 6 sys.dm_db_index_usage_statsDay 7 sys.dm_db_missing_index_group_statsDay 8 sys.dm_fts_active_catalogsDay 9 sys.dm_os_schedulersDay 10 sys.dm_exec_procedure_statsDay 11 sys.dm_db_index_usage_statsDay 12 sys.dm_db_partition_statsDay 13 sys.dm_io_virtual_file_statsDay 14 sys.dm_os_wait_statsDay 15 sys.dm_os_performance_countersDay 16 sys.dm_exec_cached_plansDay 17 sys.dm_db_index_usage_statsDay 18 sys.dm_clr_tasksDay 19 sys.dm_os_wait_statsDay 20 sys.dm_exec_cached_plansDay 21 sys.dm_os_ring_buffersDay 22 sys.dm_exec_query_memory_grantsDay 23 sys.dm_os_process_memoryDay 24 sys.dm_exec_requestsDay 25 sys.dm_os_memory_cache_countersDay 26 sys.dm_exec_procedure_statsDay 27 sys.dm_tran_locksDay 28 sys.dm_io_pending_io_requestsDay 29 sys.dm_exec_connectionsDay 30 sys.dm_os_buffer_descriptors