December 10, 2015 at 7:35 pm
Hi Team,
We have a DB which is around 500 GB. Daily back up is taken around 9 pm and it runs till 11.15 pm, and sometimes completes by 10.30 pm.
We have few jobs that start from 11pm.. So whenever backup runs beyond this time, our jobs fails due to sql timeout server not responding.
My Question:
1.Does backup cause performance issues on overall database operations?.
2. Issue is with particular job which works on the main and heavies tables in the DB, 2 jobs before this job run without any issues but they are light weight and do very few updates.
Any pointers/suggestions, will be helpful.
December 26, 2015 at 1:37 am
What are the other jobs?
Is this server already starving out of resources?
Backup job normally should not impact any other .
December 26, 2015 at 12:44 pm
Full backups are usually very IO-intense. I'd start by taking a look at the IO consumed by the other jobs. If they're IO heavy, you might need to look at moving them outside of the full backup window. If you're using Enterprise Edition, you can check out compressed backups as well.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply