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 |
|
warren2600
Starting Member
1 Post |
 Posted - 2005-09-01 : 16:24:50
|
| Until a few days ago, the backup job on one of my clusters took about 10 minutes to backup 80 dbs.Each DB averages about 100-200MBIt is now currently taking 120+ Minutes!The amount of data has not increased to warrant such a jump.No other apps, tape backups, jobs are running on this machine.There is no connection outside of our internal network.Could this be due severe physical disk defragmentation?if so, can i run a defrag without having to shut down sql?Any ideas would be greatly appreciated.ThanksWarren |
|
|
Kristen
Test
22859 Posts |
Posted - 2005-09-01 : 17:34:27
|
| Has the server become tight on disk space? That tends to cause Windows to "work harder"Has the LDF grown dramatically in size? That won't increase the size of the backups, but it does increase the time that a RESTORE takes, maybe a Backup too [but I'm not sure]Kristen |
 |
|
|
Thrasymachus
Constraint Violating Yak Guru
483 Posts |
Posted - 2005-09-02 : 08:34:57
|
| if you are sure there is increased workload, you could use profiler to isolate the dbs that are taking a long time to backup. have you run checkdb on these lately?a chkdsk on the physical drives might not be bad idea either.I do not think fragmentation is the issue here, but if you isolate the DB's taking a long time, that would be a good starting point.====================================================Regards,Sean Roussy"pimpin ain't easy, but someone has to do it" -- Pimpin Whitefolks(?) |
|
|
|
|
|
|
Increased Backup Time