SQL Server活动历史记录图表无效颜色 [英] SQL Server Activity History graph invalid colors
问题描述
大家好,
我对"服务器活动历史记录"感到有些困惑。如下图所示:
$
第一个图表是否意味着SQL Server什么都不做,但OS占用了大部分CPU?我猜这是不正确的,颜色是交换的。
来自环形缓冲区的查询显示我想说的是正确的:
列含义 - 1时间,  SQL Server进程CPU消耗百分比,空闲进程%
从Ring缓冲区中检索值的查询:
SELECT GETDATE(),
record.value('(./ Record / SchedulerMonitorEvent / SystemHealth / ProcessUtilization)[1]','int')AS [SQLProcessUtilization],
record.value('。(。/ Record / SchedulerMonitorEvent / SystemHealth / SystemIdle)[1]','int')AS [SystemIdle],
(SELECT cntr_value FROM sys.dm_os_performance_counters(NOLOCK)WHERE counter_name ='Transactions / sec'AND instance_name ='_ Total')
FROM (
SELECT TOP 1 convert(xml,record)AS [record]
FROM sys.dm_os_ring_buffers(NOLOCK)
WHERE ring_buffer_type = N'RING_BUFFER_SCHEDULER_MONITOR'
AND记录LIKE'%< ; SystemHealth>%'
ORDER BY timestamp DESC)AS x
当然,该图显示了自01/23以来的某些时间段内发生的CPU过载,我们现在正在解决这个问题,但这超出了这个问题的范围......
Hi
Pavel,
请告诉我们您的SQL Server版本。
此外,对于这个问题,我建议您通过此链接将其提交给Microsoft反馈 https://feedback.azure.com/forums/908035-sql-server 。
最好的问候,
艾米丽
Hi all folks,
I am a little bit confused by the "Server Activity History" which is showed in the following image:
Does the first graph mean the SQL Server is doing nothing but OS consumes the most of the CPU? I would guess this is not correct and the colors are swapped.
Query from Ring buffers shows what I would say is correct:
Column meanings - 1 Time, SQL Server process CPU consumption in %, Idle process %
Query to retrieve values from Ring buffers:
SELECT GETDATE(), record.value('(./Record/SchedulerMonitorEvent/SystemHealth/ProcessUtilization)[1]', 'int') AS [SQLProcessUtilization], record.value('(./Record/SchedulerMonitorEvent/SystemHealth/SystemIdle)[1]', 'int') AS [SystemIdle], (SELECT cntr_value FROM sys.dm_os_performance_counters (NOLOCK) WHERE counter_name = 'Transactions/sec' AND instance_name = '_Total') FROM ( SELECT TOP 1 convert(xml, record) AS [record] FROM sys.dm_os_ring_buffers (NOLOCK) WHERE ring_buffer_type = N'RING_BUFFER_SCHEDULER_MONITOR' AND record LIKE '%<SystemHealth>%' ORDER BY timestamp DESC) AS x
Of course, the graph shows CPU overloading which is happening in certain time frames during the day since 01/23 and which we are solving right now but that is outside of this question scope...
Hi Pavel,
Could you please tell us the version of your SQL Server.
Besides, for this question, I would suggest you submitting it to the Microsoft feedback at this link https://feedback.azure.com/forums/908035-sql-server.
Best Regards,
Emily
这篇关于SQL Server活动历史记录图表无效颜色的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!