January 24, 2013 at 11:15 am
Hi,
Looking for some opinions/links. If a SQL server (OLTP) is restricted to a single box with max 8 drives, would four RAID1 arrays (OS,TEMPDB,LOGS,DATA) be the way to go?
Or a RAID1 for OS and a 6 disk RAID10 for the rest?
Or RAID1 OS, RAID1 TEMPDB, RAID10 for the rest?
Thanks
January 25, 2013 at 2:58 am
ipgsql (1/24/2013)
Hi,Looking for some opinions/links. If a SQL server (OLTP) is restricted to a single box with max 8 drives, would four RAID1 arrays (OS,TEMPDB,LOGS,DATA) be the way to go?
Or a RAID1 for OS and a 6 disk RAID10 for the rest?
Or RAID1 OS, RAID1 TEMPDB, RAID10 for the rest?
Thanks
The first item to separate wpuld be the transaction logs. So more like this
RAID1 OS, RAID1 LOGS, RAID10 for the rest
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs"
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy