question

Heisenberg avatar image
0 Votes"
Heisenberg asked Cathyji-msft commented

CPU usage.

hello, im seeing high CPU usage on sql server. We dont have fragmentation, stats are upto date. We have 32 cores on the server . dm_os_wait_stats shows following waits. What are the areas i can look at. CPU usage is high in past couple of weeks.

wait_type waiting_task_count


MEMORY_ALLOCATION_EXT 17453797742
RESERVED_MEMORY_ALLOCATION_EXT 3326705786
SOS_SCHEDULER_YIELD 1732357515
DUMP_LOG_COORDINATOR_QUEUE 1144317473


sql-server-general
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @SQLServerBro,

We have not received a response from you. Did the reply(s) could help you? If the response helped, do "Accept Answer". If it is not, please let us know. By doing so, it will benefit all community members who are having this similar issue. Your contribution is highly appreciated.

0 Votes 0 ·
ErlandSommarskog avatar image
0 Votes"
ErlandSommarskog answered

To get any meaning out of waiting tasks, you need to sample it at two occasions and compute the deltas. Else you have values accumulated since SQL Server last started, and it may be a hotchpotch of everything.

If you are on SQL 2016 enable Query Store, if you haven't done so. After a day or so, you can start to look at resource-consuming queries. There is a UI for it in SSMS, You find it under the node for the database.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Cathyji-msft avatar image
0 Votes"
Cathyji-msft answered Cathyji-msft edited

Hi @SQLServerBro,

Could you share us the process that you troubleshoot this high CPU issue? We can follow the below steps to isolate the problem and mitigate it.
126594-screenshot-2021-08-26-110859.jpg

Please refer to below blogs to troubleshot high CPU issues.

Troubleshooting High CPU Issues in SQL Server (Part 1)
Troubleshooting High CPU issues in SQL Server (Part 2)


If the response is helpful, please click "Accept Answer" and upvote it, as this could help other community members looking for similar thread.




5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.