• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 336
  • Last Modified:

SQL005 Jobs Not working as normal

I have a SQL2005 job that restores some databases that has been running for at least a year with problems.

About a week ago the first restore in the job started taking 10 times longer to run but the following restores seemed to run normally.  Thinking that it might have something to do with the database I changed the order and used a different database as step #1.  With the order changed and a different database as Step #1 that database took 10 times longer to run and the previous #1 ran as normal.

The entire job does complete but instead of 2 hours it now takes 5 hours.

The other interesting thing is that normally I can "view history" while the job runs and watch as each step executes however now I can't see anything about the job execution until after it has completed.  

  • 2
  • 2
3 Solutions
Guy Hengel [angelIII / a3]Billing EngineerCommented:
if changing the db order does not reproduce the issue on the same database, the issue is somewhere else.
I would guess it's the disk where the restores are stored on: initial access time being changed (or the destination disk ...)

is the backup source on a dedicated disk? anything changed about that disk?
Eugene ZCommented:
please clarify:

1. "restores some databases"  - does it affect all DBs or some?
2. how fast runs backup for the "slow" restores?
3. is it the same server for bkps \restore?
4. where is the backup files location?
5. how big the "slow" dbs size? was it changed since the last "fast" run?
6. are there any related errors in the event viewer\sql errorlog?
7. is there enough cpu\memory?
8. is it native sql backup or 3rd party ?
9. if 3rd- is it compressed?
10. when did you reboot this box last time?
11. are you running anything during the "bad" time: another sql jobs? antivirus? etc
jdr0606Author Commented:
It does not appear to be job related most likely resource issues.  The steps in the job run OK some nights and much more slowly other nights.  i.e. last Wednesday night the entire job took 2:45 minutes (normal), Thursday night it took over 5 hours and Friday night 5.5hours.

Currently looking at resources other than SQL which I no longer believe is a factor.

Thanks for the input.
jdr0606Author Commented:
I've requested that this question be closed as follows:

Accepted answer: 0 points for jdr0606's comment #a39478079
Assisted answer: 250 points for angelIII's comment #a39459312
Assisted answer: 250 points for EugeneZ's comment #a39462138

for the following reason:

While the input from the experts was helpful, at the end of the day it was determined to be something not likely related to the original request.
Eugene ZCommented:
just ignore this - wrong post
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now