论坛 › SQL Server › SQL Server 环形缓冲区（Ring Buffer） -- RING_BUFFER_SCHEDULER_MONITOR 获取SQL

远行的心 发表于 2018-10-12 11:28:24

SQL Server 环形缓冲区（Ring Buffer） -- RING_BUFFER_SCHEDULER_MONITOR 获取SQL

select　　
   record
　　
,CAST(record AS XML)
　　
,CAST(record as XML).value('/Record/SchedulerMonitorEvent/SystemHealth/MemoryUtilization','int') as MemUtil
　　
,CAST(record as XML).value('/Record/SchedulerMonitorEvent/SystemHealth/PageFaults','int') as PageFaults
　　
   ,CAST(record as XML).value('/Record/SchedulerMonitorEvent/SystemHealth/WorkingSetDelta','int') as workingSetDelta
　　
    ,CAST(record as XML).value('/Record/SchedulerMonitorEvent/SystemHealth/KernelModeTime','int') as KernelModeTime
　　
    ,CAST(record as XML).value('/Record/SchedulerMonitorEvent/SystemHealth/UserModeTime','bigint') as UserModeTime
　　
    ,CAST(record as XML).value('/Record/SchedulerMonitorEvent/SystemHealth/ProcessUtilization','int') as ProcessUtilization
　　
    ,CAST(record as XML).value('/Record/SchedulerMonitorEvent/SystemHealth/SystemIdle','int') as SystemIdle
　　
from sys.dm_os_ring_buffers
　　
where
　　
ring_buffer_type = 'RING_BUFFER_SCHEDULER_MONITOR'

查看完整版本: SQL Server 环形缓冲区（Ring Buffer） -- RING_BUFFER_SCHEDULER_MONITOR 获取SQL