Some Thoughts on Clustering SQL Server Virtual Machines. 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. 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. When there is hardware or software failure of a server, the applications or clients connecting to the server will experience downtime.
When a SQL Server instance is configured to be an FCI (instead of a standalone instance), the high availability of that SQL Server instance is protected by the presence of redundant nodes in the FCI. Only one of the nodes in the FCI owns the WSFC resource group at a time. In case of a failure (hardware failures, operating system failures, application or service failures), or a planned upgrade, the resource group ownership is moved to another WSFC node. Setup for Failover Clustering. Understanding MS DTC Resources in Windows Server 2008 Failover Clusters. Updated: April 11, 2008 Applies To: Windows Server 2008 In Windows Server 2008, the Microsoft Distributed Transaction Coordinator (MS DTC) component provides support for active/active clusters in which a clustered MS DTC resource coordinates distributed transactions across a Windows failover cluster group. Clustering MS SQL Server 2008 R2 on VMware Virtual Windows Server 2008 R2 – 3. 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. To install a SQL Server failover cluster, you must create and configure a failover cluster instance by running SQL Server Setup.
This topic explains the elements of a failover cluster, as well as important information about naming a failover cluster instance. It also describes basic steps for installing a failover cluster. A failover cluster instance can run on one or more computers that are participating nodes of a failover cluster. A failover cluster instance contains: A combination of one or more disks in a Microsoft Cluster Service (MSCS) cluster group, also known as a resource group.