Posted on 2012-08-13
Last Modified: 2012-09-06
Hello Gurus

I am to deploy a SQL 2008 ERP in a Hyper-V environment.

What is the best scenario for my HDDs setup ?
I would like to benefit from a SSD Drive to get high performance on SQL.

Do I install the whole VM that contain SQL on an SSD Drive ? Or I install the VM on a "normal" RAID 5 and then the DB on a SSD ?

Thank you

(Windows 2008 R2 Enterprise - Sql 2008/2012)
Question by:ammounpierre
    LVL 116

    Expert Comment

    by:Andrew Hancock (VMware vExpert / EE MVE)
    Just use the SSD as a datastore for the database disk.

    If you want the entire VM to benefit from the SSD, use the entire SSD datastore for OS and Database disk.

    I would recommend RAID 10 for performance for any Virtual Machine.
    LVL 16

    Expert Comment

    Install the VM on normal disk and store the user databases on the SSD, also move the tempdb database to the SSD storage too. master, model, msdb are probably not that necessary.

    Also bear in mind that if your bottleneck is CPU or memory this system will not run any faster, this will just affect the read and write performance.

    Author Comment

    Thank you for the reply.

    The Physical server will be used for many VMs , but they are not "Critical" in terms of speed..(Email mDaemon,File Server,etc...)

    I was thinking about a scenario like this...
    Can u please confirm if this is the best config. ?

    Have SSD for Windows 2008 + Hyper V services. (100GB SSD)
    Have all the VMs on Raid 5 (3 HDD SAS 500GB)
    Have the SQL VM (Windows+SQL Server+DB) on a separate SSD (3*200GB Raid 1)

    LVL 46

    Assisted Solution

    Personally, I would mirror a pair of SSDs.  They aren't infallible and have read errors, and die just like mechanical drives.  In fact, many have a much shorter data retention time than a mechanical disk.  

    (They also aren't created equal.  Just like mechanical drives, they have enterprise class SSDs and more consumer class).

    Win2K8 does a wonderful job of software mirroring, and it will also handle TRIM.  Wear leveling can get tricky on some SSDs and you just don't want to burn them up after a few months if they can't get the housekeeping they need by having a config that won't let Windows send the TRIM commands.
    LVL 16

    Expert Comment

    I dont think you will see any benefit for using the SSD for the OS  of this VM. The only benifit i can think is if the system is excessively paging. In which case you are having memory issues anyway.

    As per my original post. If feel it would be better to use the SSD for the user databases and tempdb.

    From the RAID perspective, RAID 1+0 is probably the best way to go.
    LVL 46

    Accepted Solution

    A pair of software RAID-1 can easily deliver more than 100,000 random I/Os per second on reads.  You'll be lucky to get 100 with a pair of mechanical drives.

    The more your index files are getting pounded the better you will be with SSDs.  One does not buy SSD technology for throughput.  It is cheaper to get more throughput buy doubling down on mechanical drives.

    Featured Post

    IT, Stop Being Called Into Every Meeting

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Join & Write a Comment

    Suggested Solutions

    New Windows 7 Installations take days for Windows-Updates to show up and install. This can easily be fixed. I have finally decided to write an article because this seems to get asked several times a day lately. This Article and the Links apply to…
    When we have a dead host and we lose all connections to the ESXi, and we need to find a way to move all VMs from that dead ESXi host.
    This tutorial will walk an individual through locating and launching the BEUtility application and how to execute it on the appropriate database. Log onto the server running the Backup Exec database. In a larger environment, this would generally be …
    This tutorial will walk an individual through the steps necessary to install and configure the Windows Server Backup Utility. Directly connect an external storage device such as a USB drive, or CD\DVD burner: If the device is a USB drive, ensure i…

    754 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

    24 Experts available now in Live!

    Get 1:1 Help Now