admin管理员组

文章数量:1516870

（此脚本为网络参考，出处不详） 

DECLARE @ts_now bigint = (SELECT cpu_ticks/(cpu_ticks/ms_ticks)  
FROM sys.dm_os_sys_info WITH (NOLOCK));  
--	前N行则表示最近的N分钟内CPU使用情况
SELECT TOP(60) 
 DATEADD(ms, -1 * (@ts_now - [timestamp]), GETDATE()) AS [Event Time]  
,SQLProcessUtilization AS [SQL Server Process CPU Utilization]
,SystemIdle AS [System Idle Process]
,(100 - SystemIdle - SQLProcessUtilization) AS [Other Process CPU Utilization]
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);

本文标签： 使用情况揭秘中的

版权声明：本文标题：揭秘 SQL Server 中的 CPU 使用情况：快速记录最近N分钟内的波动 内容由网友自发贡献，该文观点仅代表作者本人， 转载请联系作者并注明出处：https://www.betaflare.com/web/1770511805a3255436.html， 本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌抄袭侵权/违法违规的内容，一经查实，本站将立刻删除。