what caused the previous CPU spike

Chaitanya Kiran 776 Reputation points
2021-09-29T14:55:24.543+00:00

Good Morning,

We got a CPU spike alert. When I went to the server and checked, CPU was fine. I want to know what caused the previous spike. Could you please let me know.

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,297 questions
0 comments No comments
{count} votes

Accepted answer
  1. Tom Phillips 17,721 Reputation points
    2021-09-29T15:02:43.737+00:00

    There is no way to look into the past. You would have to see it when it happens.

    However, it is perfectly normal for SQL Server to use 100% CPU for short periods of time. This is not something you should be alerting on instantly.

    0 comments No comments

2 additional answers

Sort by: Most helpful
  1. Erland Sommarskog 106.3K Reputation points MVP
    2021-09-29T21:52:55.013+00:00

    I will have to disagree with Tom. If you have Query Store active for the databases on the server, you can find information there, although it is a bit of work. First of all, Query Store is per database, so you need to compile it to a single set of table to work with.

    Also, by default, Query Store stores performance data be the hour, so if the spike was only for five minutes, it is not that easy to discern. You can change the interval down to one minute, but that is not a very good idea, and certainly not to determine the cause for a five-minute spike. After all, as Tom says, that is pretty normal.

    If the spike keeps on for several hours, there may be more reason to look into it, but in that case Query Store should quickly show which is the monster query.

    0 comments No comments

  2. Seeya Xi-MSFT 16,461 Reputation points
    2021-09-30T03:53:59.013+00:00

    Hi @Chaitanya Kiran ,

    Here are two articles to help you troubleshoot:
    Troubleshooting High CPU Issues in SQL Server (Part 1)
    Troubleshooting High CPU issues in SQL Server (Part 2)
    I believe that if it is not useful now, it could be useful later.

    Best regards,
    Seeya


    If the response is helpful, please click "Accept Answer" and upvote it, as this could help other community members looking for similar queries.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments No comments