July 31, 2006 at 12:48 pm
I have a package that does a simple truncate and copy tables from one server to another that runs twice a day. One during production hours and one during our nightly process.
My issue is that the one during production hours runs faster than the one at night. its a big difference from 30 minutes to an hour and a half.
Any suggestions on how to trouble shoot this?
July 31, 2006 at 1:15 pm
Well, I would start with finding out what else is running on your server during the night time run. Check your backup and maintenance schedule. Look in the Windows event viewer/security page to see who is authenticating into your server at that time of night. Are there network backups running at the same time? Ask your network guys what is going on at that time of night. Your slowdown is due to contention from somewhere, you just need to find out where it is comming from.
July 31, 2006 at 5:39 pm
Thanks I was able to find out there was a backup being done by the admins at the same time.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply