SQL backup job is taking way too long - 07-11-2012 , 05:47 PM
I do daily full back up of a 150G bytes database to a local drive of
its server and it took 2 hours and 45 mins. This database is on SQL
2008 standard sp3 server say server A. I have the exact same
database on a different SQL server machine say server B and it took 10
mins. The only difference is server B has SQL 2008 r2 standard sp1.
However, I also have a SQL 2008 standard sp3 machine say server C,
which is backing up a 240 Gbytes db in 20 mins. The backup job
occurred at 2:00 am on server A which should be a quiet time and I
checked if there are any jobs and windows scheduled tasks running
during the back up on server A and I found none. I ran a test backup
on server A and found IO and cpu are not being overwhelmed. In fact,
the performace encounters (average read/write queue IO) are within the
threadholds, but still the backup job is taking a long time.
What could be wrong with the backup on server A? Any thoughts on this
are very much appreciated.
Re: SQL backup job is taking way too long - 07-12-2012 , 04:39 PM
wingman (wingchoun (AT) gmail (DOT) com) writes:
Obviously, something does take very long time when you run this backup.
My gut feeling says that the cause is more likely to be found outside
SQL Server than inside.
Where is the database? On local disks as well? Or on a SAN? Have you
run DBCC on the database lately?
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se
Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx