Whitepaper : Top 5 SQL Server Cluster Setup Mistakes

  • Enterprise
  • Business Intelligence
  • Web
Presenter: Kendra Little
Share This:  Facebook Twitter LinkedIn

Windows Server Failover Clustering (WSFC) provides infrastructure features that support the high-availability and disaster recovery scenarios of hosted server applications such as Microsoft SQL Server. If a cluster node or service fails, automatically or manually transfer the services that the node hosts to another available node. This process is known as failover.

SQL Server Always On is a solution for high availability and disaster recovery that takes advantage of WSFC. Always On provides an integrated, flexible solution that increases application availability, offers better returns on hardware investments, and simplifies high availability deployment and management. Always On availability groups and Always On failover cluster instances use WSFC as a platform technology

WSFC can keep SQL Server databases online and customers happy when hardware or operating system problems strike. WSFC also makes life easier when performing maintenance on a physical server: Fail the SQL Server instance over to another server and complete the work with minimal downtime. But be careful, when misconfiguring clusters, poor SQL Server performance or extended unplanned downtime is bound to occur. Do not let an otherwise great high availability feature cause weak performance or outages.

This whitepaper provides information to help avoid the some of the most common SQL cluster setup mistakes: (1) Skipping cluster validation or ignoring warnings; (2) configuring quorum badly; (3) selecting the wrong version of Windows or SQL Server; (4) buying the wrong hardware; and (5) not planning your nodes and instances.

WSFC is a powerful technology that can keep SQL Server instances and databases online and operational when hardware fails -- which it will. Armed with the knowledge in this whitepaper, set up your next WSFC for SQL Server the right way.

Presenter: 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.

Register to read the full whitepaper.

Register for Free Whitepaper

Register For a Free Whitepaper