SQL Server Administration and Maintenance

SQT07 Introduction to SQL Server Clustering


2:00pm - 3:15pm

Level: Introductory to Intermediate

Chad Churchwell

Premier Field Engineer


This session will introduce you to clustering SQL Server for high availability. We'll 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'll also cover quorum models, shared storage requirements and also have a full clustering demo. Finally, we'll cover clustering enhancements released with SQL Server 2012 as well as SQL Server 2014.

You will learn:

  • The use case to use failover clustering with SQL Server
  • The components needed to create a SQL Server cluster
  • How to administer a SQL Server cluster as well as install a new SQL Server cluster