监控 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 闩锁等待统计信息。

文章来源于领测软件测试网 https://www.ltesting.net/