Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Suggest RAID arrays for minimal single server? Expand / Collapse
Author
Message
Posted Thursday, January 24, 2013 11:15 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, September 4, 2014 4:00 PM
Points: 7, Visits: 208
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
Post #1411273
Posted Friday, January 25, 2013 2:58 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 10:43 AM
Points: 6,641, Visits: 14,226
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"
Post #1411555
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse