Level: Intermediate to Advanced
Recent releases of SQL Server have depended a lot on Windows Server Failover Clustering for high availability and disaster recovery. This has made Availability Group (AG) and Failover Clustered Instance (FCI) deployments more complicated and challenging to maintain. In this day-long workshop, you'll learn the underlying infrastructure that is Windows Server Failover Clustering, how it works and how SQL Server leverages the technology to help you build highly available database infrastructures. This workshop will cover the following topics:
- Successfully planning and installing a WSFC for SQL Server workloads
- Understanding impacts of networking in SQL Server high availability and disaster recovery solutions
- Proper configuration of quorum
- Installing and configuring FCIs and AGs
You will learn:
- The fundamentals of WSFC
- How to successfully plan and deploy SQL Server FCIs and AGs
- Tips, tricks and best practices in planning and deployment of WSFC to support SQL Server workloads