Solved

Best disk configuration for sql server.

Posted on 2011-03-21
3
428 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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

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…
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
This video shows how to use Hyena, from SystemTools Software, to bulk import 100 user accounts from an external text file. View in 1080p for best video quality.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

770 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