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 |
|
kpsreenath
Yak Posting Veteran
52 Posts |
 Posted - 2006-03-08 : 10:10:27
|
| Users are complaining about a job running slow.Usually it takes 30 minutes.Certain days, like once in a week or so, it takes around 1hr 20minutes. This delay doesnt have any pattern.i monitored this job for somedays and this is what I could identify.1) The server is not slow,only that particular database is slow2) The days when its slow, there is a checkpoint/ghost cleanup which is running.This takes a good amount of cputime(633469) and DiskIO(23126).3) I dont see any blocking or any other major activities going on during the sametime on that database.To cover any performance related issues(incase there are any), I am planning to schedule a nightly update statistics on the tables this process accesses.These observations makes me believe that, this issue might have come up because of the checkpoint/ghost cleanup. My questionsa) Is it normal to have checkpoint/ghost clean up threads slowing down the database performance.Incase yes, is there any way as a user we can do something to make sure that the jobs runs fine.I cannot reschedule the job as this is business critical and the users loose one day of work. b) Incase its not caused by these processes, whats the next step of troubleshooting?Thanks in advanceSreenathThanksSree |
|
|
|
|
|
Business critical issue - Jobs slow