0

We have observed an unusual CPU behavior on our SQL Server 2022 (Core Edition) starting from a specific date.

The issue is that a few specific CPU cores — particularly cores 1, 7, 14, and 21 — constantly spike and remain at high utilization, even when the overall server workload decreases.

An interesting point is that when we clear the plan cache, the CPU usage immediately returns to normal for a few minutes. However, once the plan cache fills up again, the same spiking pattern reappears.

Our environment is as follows:

SQL Server version: 2022 (Core Edition)

Total memory: ~1 TB RAM

Max server memory: ~900 GB allocated to SQL Server

CPU: 112 logical cores

It seems like the issue might be related to query plan caching or a potential bug in the query processor, as the CPU load pattern is strongly tied to plan cache behavior.

Improve this question
3
  • 2
    CU11 is quite old. Did you consider patching this server? Commented Oct 7 at 7:20
  • "Starting from a specific date" > Did something happen around that time? Ex: was the server patched, upgraded, or modified? Commented Oct 9 at 13:03
  • @ImperviousInclemency what a silly question, you know the answer to this is always "we didn't make any changes and everything is exactly the same". Commented Oct 9 at 20:31

0

Reset to default

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.