CPU used query return wrong result

SVA 91 Reputation points
2024-05-30T20:18:20.67+00:00

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

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
    2024-05-31T15:16:28.5033333+00:00

    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
    2024-05-31T17:54:07.8133333+00:00

    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
    2024-06-01T02:56:32.1533333+00:00

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