Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I am now in the process of building SQL Server 2008 Enterprise failover cluster for use with 3rd party server monitoring application (which also do some OLAP analysis for trends).

Since this project will be using SQL Server 2008 Enterprise over Windows Server 2008 failover cluster, I wonder do I have to separate the DB engine instance and the OLAP component or just make it as single instance altogether ?

yes I'll use the Physical RDM capabilities so that i can use the built in EMC CX Snapview for data replication to my DR site because the two VMs will be deployed across two different locations

I am looking for any specific tweaking for the VMware: maybe enabling the MMU and using VMXNet 3 and Paravirtual for the boot device ?

or within SQL Server eg. large pagefile in RAM, etc...

Any other suggestion and idea in tweaking and performance tuning of this failover clustering on top of VMware ESX will be greatly appreciated.



share|improve this question
You can't use a Paravirtual controller for the boot device. – Massimo May 26 '11 at 14:47
oh ? but I'm using vSPhere 4.1 now and Windows Server 2008 as the guest OS in the VM ? – Server System Specialist May 26 '11 at 23:15
It doesn't matter, the paravirtual controller can only be used for non-boot disks. – Massimo May 27 '11 at 0:21

Wmware has a good guide for deploying MSSQL cluster on ESX. It includes many best practices for configuration.

share|improve this answer
now i decided to re-think and draw again from scratch as previously it was my idea at 1 AM, so it seems that Failover clustering on top of VMware HA is too complex to implement and slight downtime ~ 5 mins during the failback/server restart is acceptable for me, therefore I have now decided to go with SQL Server 2008 Mirroring HA (see the attached).>; the latest diagram. – Server System Specialist Jun 1 '11 at 4:19

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.