June 11, 2009 at 12:27 am
Hi All,
As i am new to optimization
please suggest for folling question
To check that the CPU utilization should not go beyond 30% when we are executing any heavy query, as of now sometimes it reaches 80 – 90% threshold.
1) what are the symptom that i have to take for not exceeds mor than 30%?
2) If some on can please send the links to know about it .
Regards
sat
June 11, 2009 at 8:26 am
Without knowing what your query is doing and what your structure looks like, it's just not possible to answer this question.
If you can, please post the query, the actual execution plan for the query (you can save it as a .sqlplan file, zip it, and attach it), DDL that defines your structure and, if possible, some sample data. With that information, it will be possible to provide answers.
Otherwise, the best I can offer is you might want to pick up a copy of my book.
"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
June 11, 2009 at 9:19 am
SQL Server uses the resources it needs for queries. Any query could run the CPU to 100%, and that's fine for short periods of time. If it lasted more than a few minutes, I would check into it, but spikes above 30% are not an issue in most cases.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply