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.