監控 SQL Server 的運行狀況

　　cpu_count,

　　hyperthread_ratio,

　　scheduler_count,

　　physical_memory_in_bytes / 1024 / 1024 as physical_memory_mb,

　　virtual_memory_in_bytes / 1024 / 1024 as virtual_memory_mb,

　　bpool_committed * 8 / 1024 as bpool_committed_mb,

　　bpool_commit_target * 8 / 1024 as bpool_target_mb,

　　bpool_visible * 8 / 1024 as bpool_visible_mb

　　from sys.dm_os_sys_info

　　select

　　cpu_count,

　　hyperthread_ratio,

　　scheduler_count,

　　physical_memory_in_bytes / 1024 / 1024 as physical_memory_mb,

　　virtual_memory_in_bytes / 1024 / 1024 as virtual_memory_mb,

　　bpool_committed * 8 / 1024 as bpool_committed_mb,

　　bpool_commit_target * 8 / 1024 as bpool_target_mb,

　　bpool_visible * 8 / 1024 as bpool_visible_mb

　　from sys.dm_os_sys_info

　　I/O 瓶頸

　　檢查閂鎖等待統計信息以確定 I/O 瓶頸。運行下面的 DMV 查詢以查找 I/O 閂鎖等待統計信息。

文章來源于領測軟件測試網 http://www.kjueaiud.com/