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 |
|
sureshot
Yak Posting Veteran
72 Posts |
 Posted - 2006-05-07 : 12:16:23
|
| I've got a 160GB DB running on a RAID 1+0 8 disk array. I've read that filegroups aren't necessarily when you're running RAID as the RAID itself will share the load amongst the disks. Still it's taking 50 minutes for a checkdb and 7 hours for a backup and other I/O operations can go long. We also get the warning in the logs about I/O taking more than 15 seconds.- Would filegroups help at all?- Do we just simply need more disks in the array?- Writes/Sec were at 120 and the disk queue length was 1.5 during a checkb |
|
|
Kristen
Test
22859 Posts |
Posted - 2006-05-08 : 11:24:35
|
| 7 hours to backup 160GB seems a long time ...Are Logs and Data files on separate disk channels?Is the backup on yet another channel?The backup is to DISK and NOT to Tape, right?Maybe look at Litespeed - dramatically reduces backup time, so I hear.Kristen |
 |
|
|
sureshot
Yak Posting Veteran
72 Posts |
Posted - 2006-05-08 : 14:13:53
|
| We're investigate Red Gate SQL Backup and that seems to work ok. Yes logs and data are on separate volumes. We've looked at LiteSpeed and their license fees are quite high for our situation, but we are having a look at Red Gate SQL Backup that also does the same thing.Yes backup to local disk (D DRIVE)We have the database files on fibre channel attached storage arrays(L DRIVE) RAID 1 - Logs(S DRIVE) RAID 1+0 - Data,TempDBI'm considering moving tempdb to the L drive. I've heard it should be its own volume altogether for SQL 2005 but we've got a bunch of disks on L and I don't believe we have room in the storage array to create another volume so I think it might be OK sharing the L Drive. |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2006-05-08 : 14:31:57
|
| Just a thought:The target folder for Backups isn't compressed (NTFS compression I mean) is it?Is there an INDEX REBUILD or some other scheduled task that is running during the backup which is maybe slowing it down?Kristen |
|
|
|
sureshot
Yak Posting Veteran
72 Posts |
Posted - 2006-05-08 : 16:48:42
|
| Negative on both. |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2006-05-08 : 17:01:13
|
| Darn it! Sorry, fresh out of ideas - although, unless someone disagrees, I still think that 7 hours is a long time for backup of a 160GB database ...Kristen |
|
|
|
|
|
|
Slow CHECKDB + Backup