Share via

data collecrion report sql server

sankalp agrawal 1 Reputation point
2022-03-04T23:35:04.487+00:00

I have setup data collection report for a sql instance.
in the server activity report sql cpu utilization is have spikes greater than overall system CPU utilization
how is that even possible

180208-image.png

SQL Server | Other
SQL Server | Other

Additional SQL Server features and topics not covered by specific categories

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. CathyJi-MSFT 22,431 Reputation points Microsoft External Staff
    2022-03-07T07:17:46.877+00:00

    Hi @sankalp agrawal ,

    Which tool did you use to monitor CPU? Performance monitor? Which counters did you choose?

    By the way, we can follow below steps to troubleshoot high CPU issue.

    180576-screenshot-2022-03-07-151457.jpg

    Refer to the blog How to troubleshoot high CPU utilization issue in SQL Server to get detail steps.

    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    Was this answer helpful?

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.