We have a SP Farm where the Backup sometimes takes 4h (normal) but sometimes takes 6 or 9h.
The strange is that sometimes the backup is 270Gb and takes 4h and sometimes has 240GB and takes 7h...
[22-09-2010 3:43:09]: Verbose: [DB1] SQL Server Message: BACKUP DATABASE successfully processed 28.201.667 pages in 13675.925 seconds (16.893 MB/sec).
[23-09-2010 7:36:15]: Verbose: [DB1] SQL Server Message: BACKUP DATABASE successfully processed 29259332 pages in 27657.097 seconds (8.666 MB/sec).
During this time nothing is running, just other backups, and those end always at the same time
Probably a concurrency problem? In SQL IO?
What are the best ways to debug this? Add some performance monitor in Sql?
View Complete Post