New SQL Server 2008 System Environment

Posted on 2009-04-23
Last Modified: 2012-05-06
We are taking new SQL server 2008 to use. There will be arround 10 intances and 100 users. This server have two quad core processors and 18Gb memory.

Do you think that RAID 5 (15k drives) would be enough or should i use RAID 0+1 (i would save quite much drives if i use RAID5?

How about volumes.OS would have own volume of course. How about other volumes. Is it ok to install all intances in one volume or what would be the best practize?
Question by:thaapavuori
    LVL 39

    Accepted Solution

    Split data, log and tempdb.  RAID 10 is the most costly on disk for a reason.  It performs the best.  10 instances and 100 users is NOT a lot and RAID 5 would probably be OK (IMO).
    LVL 3

    Expert Comment

    Best bet is to invest in the performance solution off the bat rather than trying to do it post production and after problems.
    2 disk Raid 1 for OS, another 2 disk Raid 1 for logs, another 2 disk raid 1 for data, or a 3 disk Raid 5 for the data.

    Depending on the budget. Also, there is another question similar to this on EE. Check out:


    Featured Post

    How to improve team productivity

    Quip adds documents, spreadsheets, and tasklists to your Slack experience
    - Elevate ideas to Quip docs
    - Share Quip docs in Slack
    - Get notified of changes to your docs
    - Available on iOS/Android/Desktop/Web
    - Online/Offline

    Join & Write a Comment

    Hi all, It is important and often overlooked to understand “Database properties”. Often we see questions about "log files" or "where is the database" and one of the easiest ways to get general information about your database is to use “Database p…
    In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
    This video is in connection to the article "The case of a missing mobile phone (". It will help one to understand clearly the steps to track a lost android phone.
    Here's a very brief overview of the methods PRTG Network Monitor ( offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…

    734 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