Whitepaper : Top Five SQL Server Cluster Setup Mistakes

Windows Failover Clustering can keep your SQL Server databases online and your customers happy when hardware or operating system problems strike. Failover Clustering also makes your life easier when you need to do maintenance on a physical server: just fail your SQL Server instance over to another server and complete your work with minimal downtime. However, be careful: If you misconfigure your cluster, then you are bound for poor SQL Server performance or extended unplanned downtime. You should not let an otherwise great high availability feature cause weak performance or outages. Let us learn how to avoid some of the most prevalent SQL Server cluster setup mistakes.

This whitepaper presents the top five mistakes that you can make for SQL Server Failover Clusters. It discusses: (1) Not planning your nodes and instances. (2) Buying the wrong hardware. (3) Selecting the wrong version of Windows or SQL Server. (4) Configuring quorum badly. (5) Skipping cluster validation (or ignoring warnings).

Author: Kendra Little

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.

See Also:

Topics : Database Diagnostics,Database Monitoring,Database Performance,

Products : SQL Diagnostic Manager for SQL Server,

Register for Free Whitepaper

Note: By filling and submitting this form you understand and agree that the use of IDERA’s website is subject to the General Website Terms of Use. Additional details regarding IDERA’s collection and use of your personal information, including information about access, retention, rectification, deletion, security, cross-border transfers and other topics, is available in the Privacy Policy.