Here’s how to fix high CPU usage by SQL server

by Aleksandar Ognjanovic
Aleksandar Ognjanovic
Aleksandar Ognjanovic
Troubleshooting Expert
Aleksandar's main passion is technology. With a solid writing background, he is determined to bring the bleeding edge to the common user. With a keen eye, he always... read more
Affiliate Disclosure

To fix various PC problems, we recommend Restoro PC Repair Tool:
This software will repair common computer errors, protect you from file loss, malware, hardware failure and optimize your PC for maximum performance. Fix PC issues and remove viruses now in 3 easy steps:

  1. Download Restoro PC Repair Tool that comes with Patented Technologies (patent available here).
  2. Click Start Scan to find Windows issues that could be causing PC problems.
  3. Click Repair All to fix issues affecting your computer's security and performance
  • Restoro has been downloaded by 0 readers this month.

When your SQL server skyrockets in regards to CPU usage, chances are you’ll be able to find out what’s happening rather simply. If the server restart isn’t an option at the time being, the steps below should help you easier determine what’s causing high CPU usage.

If you’re unable to find your way around on your own, consider contacting your server administrator.

How to reduce high CPU usage by SQL server

The second thing you need to do is examine the ring buffers to get the historical data. Since SQL stores all historical data, you can query for a report about the recent activity. This way, we can find out what’s causing enormous CPU spikes.

The next step is to determine which exact inside process is consuming data. Common reasons for high CPU activity on a SQL server are System tasks, Excessive Compilation/Recompilation of queries, or Query executing.

Now you’ll need to check all currently executing queries on your server. Once you’ve got the list of all available queries, it’s rather simple to determine which exact query execution is causing the error.

The best way to do all this is with the SQL Server 2005 Performance Dashboard Reports utility. It provides you with both numerical and graphical feedback.

Of course, it’s important to check other system services and determine that SQL perfmon is causing the problem. With that said, we can conclude this article.

If you’re unable to resolve the problem, consider posting on a variety of dedicated forums where professionals and tech-savvy users can help you.


Still having issues? Fix them with this tool:


If the advices above haven't solved your issue, your PC may experience deeper Windows problems. We recommend downloading this PC Repair tool (rated Great on to easily address them. After installation, simply click the Start Scan button and then press on Repair All.

This article covers:Topics: