I don't think your query is wrong. Rather, it may be that the ring buffer is not as exact as we may desire.
I don't have access to a machine with that many CPUs, so I cannot test myself.
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Hi,
After the CPU upgrade to 98 cores when I execute the query to find the sqlserver usage and system idle shows the result more than 100%.
for example
SQL Server process utilization - 20
System idle process - 89
The query which I used was Please help what change i need to do to get the correct result
Thanks
I don't think your query is wrong. Rather, it may be that the ring buffer is not as exact as we may desire.
I don't have access to a machine with that many CPUs, so I cannot test myself.
Windows 2022 with SQL Server 2019, 32 cores, query returns correct/logical result, so I can't reproduce the issue.
I have a machine that has 128 and I cannot reproduce the issue.