A DMV a day

Series, SQL Server

by Glen Berry

Day 1 sys.dm_os_buffer_descriptors
Day 2 sys.dm_exec_sessions
Day 3 sys.dm_os_sys_info
Day 4 sys.dm_os_sys_memory
Day 5 sys.dm_db_mirroring_auto_page_repair
Day 6 sys.dm_db_index_usage_stats
Day 7 sys.dm_db_missing_index_group_stats
Day 8 sys.dm_fts_active_catalogs
Day 9 sys.dm_os_schedulers
Day 10 sys.dm_exec_procedure_stats
Day 11 sys.dm_db_index_usage_stats
Day 12 sys.dm_db_partition_stats
Day 13 sys.dm_io_virtual_file_stats
Day 14 sys.dm_os_wait_stats
Day 15 sys.dm_os_performance_counters
Day 16 sys.dm_exec_cached_plans
Day 17 sys.dm_db_index_usage_stats
Day 18 sys.dm_clr_tasks
Day 19 sys.dm_os_wait_stats
Day 20 sys.dm_exec_cached_plans
Day 21 sys.dm_os_ring_buffers
Day 22 sys.dm_exec_query_memory_grants
Day 23 sys.dm_os_process_memory
Day 24 sys.dm_exec_requests
Day 25 sys.dm_os_memory_cache_counters
Day 26 sys.dm_exec_procedure_stats
Day 27 sys.dm_tran_locks
Day 28 sys.dm_io_pending_io_requests
Day 29 sys.dm_exec_connections
Day 30 sys.dm_os_buffer_descriptors

Annunci