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-02-25 : 18:01:30
|
| Hi I have regular complaints from the users that a job is running slow during 12:30 am to 1:30 am. This is a critical daily job, but the delay doenst happen regularly.I checked the cpu and sever performance and everything looks fine during this time.These processes are running on the same database during that particular time.Not sure whether these processes are creating problem or not1) checkpoint2) ghost cleanupI checked the other processes, but there is nothing which is blocking the job on the same database.Is there anyway we can avoid thisThanksSreenath |
|
|
JoeNak
Constraint Violating Yak Guru
292 Posts |
Posted - 2006-02-27 : 10:52:16
|
| Sounds like you might want to run a trace to see what's actually going on during this time. |
 |
|
|
|
|
|
job running slow