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

Rispondi

Inserisci i tuoi dati qui sotto o clicca su un'icona per effettuare l'accesso:

Logo WordPress.com

Stai commentando usando il tuo account WordPress.com. Chiudi sessione / Modifica )

Foto Twitter

Stai commentando usando il tuo account Twitter. Chiudi sessione / Modifica )

Foto di Facebook

Stai commentando usando il tuo account Facebook. Chiudi sessione / Modifica )

Google+ photo

Stai commentando usando il tuo account Google+. Chiudi sessione / Modifica )

Connessione a %s...