Overnight SQL Server Full Backup taking 4x longer, everything else slower, RAID problem?
- by Tom
Sql Server on Windows Server 2008:
Overnight, fullbackups taking 7-10 hours instead of 1-3
transaction logs taking 4-5 minutes instead of 1 minute
Query optimization taking 3x longer
I'm feeling like a disk in my Raid Array (raid5) is faulty or the raid controller or network card, Rackspace is telling me everything is fine.
Any ideas on what/how I need to check?