查CPU使用情况

----下面的查询返回过去256分钟CPU使用的历史状况,1分钟一个间隔:
DECLARE @ts_now BIGINT = (
            SELECT cpu_ticks / (cpu_ticks / ms_ticks)
            FROM   sys.dm_os_sys_info WITH (NOLOCK)
        );  
SELECT TOP(256) SQLProcessUtilization  AS [SQL Server Process CPU Utilization],
       SystemIdle                      AS [System Idle Process],
       100 - SystemIdle - SQLProcessUtilization AS [Other Process CPU Utilization],
       DATEADD(ms, -1 * (@ts_now - [timestamp]), GETDATE()) AS [Event Time]
FROM   (
           SELECT record.value('(./Record/@id)[1]', 'int') AS record_id,
                  record.value(
                      '(./Record/SchedulerMonitorEvent/SystemHealth/SystemIdle)[1]',
                      'int'
                  )  AS [SystemIdle],
                  record.value(
                      '(./Record/SchedulerMonitorEvent/SystemHealth/  
ProcessUtilization)[1]',
                      'int'
                  )  AS [SQLProcessUtilization],
                  [timestamp]
           FROM   (
                      SELECT [timestamp],
                             CONVERT(XML, record) AS [record]
                      FROM   sys.dm_os_ring_buffers WITH (NOLOCK)
                      WHERE  ring_buffer_type = N'RING_BUFFER_SCHEDULER_MONITOR'
                             AND record LIKE N'%<SystemHealth>%'
                  )  AS x
       )                               AS y
ORDER BY
       record_id DESC OPTION(RECOMPILE);  

  • 0
    点赞
  • 1
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值