On my blog post Virtualizing SQL on VMware Reference List , Oscar Zamora ( Blog | Twitter ) asked the following question in a comment: As a virtualized instance has the benefit of "failing over" to another physical box, would you consider clustering a virtualized instance? The answer to this question more than I want to write up in a comment, so I decided instead to blog my response. Since at least ESX 3, VMware has provided a number of high availability features in their enterprise server virtualization product. A detailed listing of the HA features available in VSphere 4 can be found in the vSphere Availability Guide . Some Thoughts on Clustering SQL Server Virtual Machines
Virtualizing SQL on VMware Reference List I’ve been managing SQL Server virtualized in production environments for nearly five years now, and in that time, I’ve had to do a significant amount of reading/learning about VMware as a hypervisor so that I could properly track down performance problems and in a lot of cases, prove to vendors that the problem wasn’t virtualization. It wasn’t very long ago that nobody supported virtualization, including Microsoft, despite the fact that it generally wasn’t the cause of problems. Lately I’ve seen more people virtualizing SQL Servers and asking questions about running SQL Server in a virtualized environment and in a lot of cases, when the platform selected is VMware, I can answer their questions by pointing them to one of the many whitepapers I’ve read over the last few years. To make this easier, and to share what I consider to be important references for VMware I am going to list them in this blog post by category.
Getting Started with SQL Server 2008 R2 Failover Clustering An FCI runs in a WSFC resource group with one or more WSFC nodes. When the FCI starts up, one of the nodes assume ownership of the resource group and brings its SQL Server instance online. The resources owned by this node include: Network name IP address Shared disks SQL Server Database Engine service SQL Server Agent service SQL Server Analysis Services service, if installed One file share resource, if the FILESTREAM feature is installed
Setup for Failover Clustering
Clustering MS SQL Server 2008 R2 on VMware Virtual Windows Server 2008 R2 – 3 | IPSURE (Hands-On) Hi folks This is the third and the last part of our article series about MS SQL Server 2008 R2 clustering and untill now we completed the creation of virtual machines and Windows clustering on them. In this last part, I will install MS SQL Server 2008 R2 on these virtual clustered machines. But first of all, I want to talk a little bit about MS SQL Server clustering options.
Installing a SQL Server 2008 R2 Failover Cluster