December 6, 2024 at 7:01 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 12:57 pm
Multiple posts on the same topic just confuses things. Let's keep the discussion on this, over here at the link. Thanks!
"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 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy