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.