We help IT Professionals succeed at work.

Check out our new AWS podcast with Certified Expert, Phil Phillips! Listen to "How to Execute a Seamless AWS Migration" on EE or on your favorite podcast platform. Listen Now

x

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

Medium Priority
852 Views
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.

Tony

Comment
Watch Question

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.
Top Expert 2010
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION
Top Expert 2010

Commented:
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 http://www.vmware.com/files/pdf/perf_vsphere_sql_scalability.pdf 

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

Good Luck
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.