Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
prodigy2006
Yak Posting Veteran
66 Posts |
 Posted - 2009-01-14 : 17:42:48
|
| I'm having an issue in my current project.The CPU Utilization of my SQL Server stays on 99% for 6-7 hours duration. Reason being, most of my jobs run during that period. I tried to re-schedule few jobs but my manager was stubborn that all the jobs need to run during that period only.Is there a way out of this bcoz I'm sure this server is gonna crash if the utilization stays on 99% for few more days.Thanks,Sunny. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-01-14 : 17:44:31
|
| What jobs are doing? |
 |
|
|
prodigy2006
Yak Posting Veteran
66 Posts |
Posted - 2009-01-14 : 17:50:34
|
quote:
Originally posted by sodeep
What jobs are doing?
The unfortunate thing is that the code that rookies created hasn't been changed for the past decade and I totally believe that this is the reason.Thanks Tara for that answer that servers are not gonna crash and it gives me great relief.Any suggestions how could I get that utilization down. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-01-14 : 20:18:56
|
| Find CPU utilization Queries with Standard reports and start tuning them. |
|
|
|
svicky9
Posting Yak Master
232 Posts |
Posted - 2009-01-15 : 16:48:42
|
| Just do all the performance tasks before the jobs start. Like Building Indexes, Backup and Truncation of logs , update stats..Also check the Event Viewer and sql server logs if you can get any hint?Good LuckVichttp://vicdba.blogspot.com |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-01-15 : 16:54:30
|
quote:
Originally posted by svicky9
Just do all the performance tasks before the jobs start. Like Building Indexes, Backup and Truncation of logs Why this needs to be done?, update stats..Also check the Event Viewer and sql server logs if you can get any hint?Good LuckVichttp://vicdba.blogspot.com
|
|
|
|
|
|
|
CPU utilization