• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 212
  • Last Modified:

Ideal disk configuration...

If you had a virtually unlimited number of physical drives (ie...a SAN with lots of drives)...how would you lay out your new SQL Server installation?

My thoughts:

Local drives: O/S and SQL Server binaries
San Drives:

E: Data files, raid 10
F: Log files, raid 10
G: Backups, raid 5
H: tempDB, raid 5

2 Solutions
Jim P.Commented:
How many disk controllers do you have?

If you have only 1 disk controller that becomes your choke point. I also wouldn't worry about splitting the tempdb and the backups, unless you're doing a 5 minute backup cycle.
Scott PletcherSenior DBACommented:
I think that's about right.  But personally, I would:

have local drives RAIDed/mirrored if at all possible

suggest RAID 10 for the tempdb, if possible.

separate the data and indexes onto separate RAIDs (you did say "virtually unlimited" :-) )

Featured Post

Prep for the ITIL® Foundation Certification Exam

December’s Course of the Month is now available! Enroll to learn ITIL® Foundation best practices for delivering IT services effectively and efficiently.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now