March 3, 2005 at 9:11 am
I need some advice on how to set up the most optimal drive configuration for a new MS SQL Server machine.
Which version of RAID would you choose? Is it best to have 3 separate controllers attached to 3 separate sets of drives with one each reservered for Data, Indexes, and Transaction logs? Or is there a better way?
--Frank
March 3, 2005 at 9:41 am
I believe RAID10 is the most preferred config for SQL Server. And, yes, a separate controller card for 3 different arrays would also be optimal.
As far as your assignments, I don't think is Data, Indexes, and transaction logs. Rather:
1) OS, paging file, SQL program files
2) SQL objects (tables, indexes, sp's, etc)
3) Transaction logs and temp DB.
All of the above is off the top of my head - you will want to confirm this...
March 4, 2005 at 3:27 am
Really it depends on the budget and most RAID controllers are dual channel. Remember to assign disks to thr ight channel and don't cross mix them. I like
RAID 1 - OS, SQL install and page file
RAID 0 - tempdb (depends on how heavily used it is)
RAID 1 or 10 - Log files
RAID10 - Data files
RAID 5 - Backups
There goes your budget - hehe.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply