CPU used query return wrong result

SVA 91 Reputation points


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


SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,067 questions
{count} vote

3 answers

Sort by: Most helpful
  1. Erland Sommarskog 103.5K Reputation points MVP

    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.

    0 comments No comments

  2. Olaf Helper 42,386 Reputation points

    Windows 2022 with SQL Server 2019, 32 cores, query returns correct/logical result, so I can't reproduce the issue.

    0 comments No comments

  3. Ben Miller-(DBADuck) 0 Reputation points MVP

    I have a machine that has 128 and I cannot reproduce the issue.