Daily Series: A DMV a day

Glen Berry in questa serie di posts ci porta all’interno delle DMVs più utilizzate per monitorare SQL Server.

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