May 16, 2011 at 1:01 am
Hi,
I have sqlserver 2000 dev env. In that we used to run the sql job daily. This job will call to 71 dts packages. Usually the job has to be completed with in 7 hrs. But now a days the job completion time
Discrepancy. two days before the job has been completed with in 12 hrs. The day before yesterday the job has been finished in 5 hrs and 30 mins. But yesterday the job has been completed by 28 hrs.
Indexes are good
Table Statistics are upto date
I would really appreciate, If any one share with the answer. and let me know,
is it require to restart the sqlserver services for this dev box.
Thanks in advance
Regards
Balaji G
May 16, 2011 at 9:22 am
That's like saying it took me 2 hours to get to work yesterday but it normally takes me 1 hour. Why?
There's no way we can know what took longer. Can you check the time for each package and see if one is running longer? Perhaps there was blocking? Perhaps something else. There's no general answer here
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply