Analyzing resource wait related to memory/IO bottleneck

Analyzing resource wait related to memory bottleneck (RESOURCE_SEMAPHORE, PAGEIOLATCH_XX)

sys.dm_os_wait_stats
sys.dm_os_waiting_tasks
sys.dm_exec_requests
Analyzing queries cause the most physical reads (total_physical_reads)
sys.dm_exec_query_stats
sys.dm_exec_procedure_stats
Analyzing tables/indexes cause the most page IO latch wait (page_io_latch_wait_in_ms)
sys.dm_db_index_operational_stats
Analyzing tables/indexes consume the most buffer pool memory
sys. dm_os_buffer_descriptors

 

posted on 2017-11-23 10:17  王.小辉  阅读(162)  评论(0编辑  收藏  举报

导航