Can we get away with using RDM for MSCS on a ESX 4.0 host-host active/passive cluster

Posted on 2011-04-18
Last Modified: 2012-05-11
Hi all,

We are considering an active/passive cluster for our SQL 2008 Standard R2 database server in our remote datacentre. Currently there are two ESX hosts out there so we want to have clustering across hosts incase one fails. The SQL server is running Windows Server 2008 Ent R2. The shared storage is an AMS2100 with SAS  drives. The SAN has built in thin provisioning so LUNs are created from an over-alocated storage pool.

The big question is that we want to use VMFS for the cluster and not RDM if at all possible. This enables easy backup of the Virtual Machine. Can we use VMFS drives only?

Also, if anyone else has been through this I'd like to hear other suggestions on how to provide redundancy for SQL and what you would recommend. Clustering is only a consideration at the moment.

Thanks for your responses.


Question by:ams_group
    LVL 8

    Expert Comment

    Well ... If you have vMotion support in you ESX servers, it's a far better/easier way to protect yourself from a failing ESX host.

    What exacly do you want to protect yourself from?

    By the way, it's not recommended to run SQL Server in a VM if you're goingto put any significant load it. It will have IO problems.
    LVL 28

    Accepted Solution

    You need this reference document:

    Look at the section on clustering virtual machines across physical hosts -- you will need RDMs set up.

    Sorry for the bad news - Good Luck

    LVL 28

    Expert Comment

    As far as recommendations - my remote SQL for my DR environment is NOT in a MSCS cluster - instead I depend on VMware's HA for SQL availability. It is also on a Hitachi AMS2100 utilizing wide striping (raid 5), and I use VMFS datastores for database and log. If I was really concerned about performance I would use raid 10 for logs...

    In my shop SQL does not sustain a very high I/O load as most of my database work is on Oracle RAC clusters across physical machines.

    For more info on performance of SQL on VMware as opposed to running on physical machines take a look at the whitepaper

    Performance and Scalability of Microsoft® SQL Server® on VMware vSphere™ 4

    Good Luck

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Usually shares are where we want them for our users and we tend to take them for granted. There are times, however, when those shares may disappear causing difficulty for your users. One of the first things to try is searching for files that shou…
    More or less everybody in the IT market understands the basics of Networking, however when we start talking about Storage Networks, things get a bit dizzier, and this is where I would like to help.
    Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
    This video shows you how easy it is to boot from ISO images for virtual machines with the ISO images stored on a local datastore on the ESXi host.

    779 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

    15 Experts available now in Live!

    Get 1:1 Help Now