Solved

Best disk configuration for sql server.

Posted on 2011-03-21
3
426 Views
Last Modified: 2012-05-11
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?



0
Comment
Question by:crcsupport
3 Comments
 
LVL 3

Assisted Solution

by:rkharko
rkharko earned 100 total points
ID: 35186831
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
 
LVL 14

Assisted Solution

by:Daniel_PL
Daniel_PL earned 200 total points
ID: 35186919
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
 
LVL 55

Accepted Solution

by:
andyalder earned 200 total points
ID: 35190582
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

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Every server (virtual or physical) needs a console: and the console can be provided through hardware directly connected, software for remote connections, local connections, through a KVM, etc. This document explains the different types of consol…
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
This demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.
I designed this idea while studying technology in the classroom.  This is a semester long project.  Students are asked to take photographs on a specific topic which they find meaningful, it can be a place or situation such as travel or homelessness.…

919 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now