Windows Failover Clustering can keep your SQL Server databases online and your end users happy when hardware or operating system problems strike. When equipment fails, Windows Failover Clustering is a high technology that can keep SQL Server instances and databases online and working when the inevitable happens. Failover Clustering also helps with maintenance on a physical server: Fail a SQL Server instance over to another server and complete the work with minimal downtime.
However, misconfiguring clusters can lead to poor SQL Server performance or extended unplanned downtime. Do not let an otherwise great high availability feature cause weak performance and outages.
The 13-page whitepaper “Top 5 SQL Server Cluster Setup Mistakes” by Kendra Little discusses how to avoid some of the most prevalent SQL cluster setup mistakes.
Properly plan the nodes and instances and size the hardware, select the correct version of Windows and SQL Server, properly configure quorum, and do not skip cluster validation and ignore warnings.
With the knowledge in this paper, set your next SQL Server Failover Cluster the right way.
The author, Kendra Little, has been working with SQL Server for more than ten years. She has performance-tuned databases ranging from 1 gigabyte to 80 terabytes. Kendra is also a Microsoft Certified Master in SQL Server.