Best disk configuration for sql server.

I need to upgrade my server for sql which has 70 concurrent users and 30GB db.
I read in internet, still can't decide which one is better. What I was thinking is, two sets of RAID1 as below.  

2 x RAID 1
RAID1 A hosts OS and log
RAID1 B hosts db

Or
2 x RAID 1
RAID1 A hosts OS and db
RAID1 B hosts log
?


How about RAID 10 and putting everything on the volume?



LVL 1
crcsupportAsked:
Who is Participating?
 
andyalderConnect With a Mentor Commented:
Given the 4 disks you have I'd go for your first option, hoping the DB isn't too write intensive so the log file won't be very busy.
0
 
rkharkoConnect With a Mentor Commented:
I recomment to use 120 GB SSD drive - it is faster than any Raid configuration
The optimal choice can be  OCZ Vertex 2 120GB
0
 
Daniel_PLConnect With a Mentor DB Expert/ArchitectCommented:
Hi,
It depends on how many disks you have. You can read about it in verry nice article, it contains comparison of few concept model:
http://www.mssqltips.com/tip.asp?tip=1328

0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.