December 6, 2024 at 7:02 am
I am having problems with CPU performance on SQL Server 2005. CPU spikes frequently to 90-100% for no apparent reason. I have checked the running jobs and queries but found nothing unusual. The server has about 30 concurrent connections and the database is about 5GB.
- Check long queries and optimize them.
- Use SQL Profiler to monitor activity.
- Check other performance metrics such as I/O and memory.
Can anyone suggest any additional methods or tools to identify and fix this issue? I would appreciate your help.
December 6, 2024 at 8:36 am
December 6, 2024 at 9:09 am
This was removed by the editor as SPAM
December 6, 2024 at 1:01 pm
Just what you say. Capture query metrics with Trace (and you have no idea how painful that was for me to type, #TeamXE) to see which ones are using CPU. Look at the DMVs to see which queries in cache, on average, use the most CPU. But, also, look outside of queries to server processes. Do you have virus checking running on the server? Third party backup tools? Something else? It's all about investigating to find out what is happening during those periods.
Also, gotta say it, 2005 is utterly unsupported any more. Strong recommendation that it's time for an upgrade.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply