Level: Introductory

Chad Churchwell

Premier Field Engineer

Microsoft

In this session, you'll receive an introduction to clustering SQL Server for high availability.

This session will be an introduction to clustering SQL Server for high availability. We will cover the architecture of what all is needed to create a cluster, the piece each component plays with regards to SQL Server. The differences between a clustered SQL instance and a stand-alone SQL instance will be discussed. We will cover quorum models, shared storage requirements and also have a full clustering demo. Finally, we will cover enhancements for clustering that were released with SQL Server 2012 as well as SQL Server 2014.

• Understand the use case to use failover clustering with SQL Server
• Understand the components needed to create a SQL Server cluster
• Leave with the knowledge and insight to feel comfortable administering a SQL Server cluster as well as installing a new SQL Server cluster