Level: Introductory to Intermediate
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