Overnight SQL Server Full Backup taking 4x longer, everything else slower, RAID problem?

Posted by Tom on Server Fault See other posts from Server Fault or by Tom
Published on 2010-04-29T15:01:24Z Indexed on 2010/04/29 15:07 UTC
Read the original article Hit count: 309

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?

© Server Fault or respective owner

Related posts about windows-server-2008

Related posts about sql-server