Solved

Best disk configuration for sql server.

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

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Suggested Solutions

SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server instance. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties …
Learn about cloud computing and its benefits for small business owners.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
You have products, that come in variants and want to set different prices for them? Watch this micro tutorial that describes how to configure prices for Magento super attributes. Assigning simple products to configurable: We assigned simple products…

760 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

22 Experts available now in Live!

Get 1:1 Help Now