SQL Server Clustering Basics for the DBA

2016

TL; DR

Windows failover clustering is the foundation for clustered instances and availability groups. A successful DBA needs to understand the underlying Windows portion of clustering. This session will show what you need to know

Session Details

While you can see how to run through Setup to deploy a clustered instance of SQL Server (FCI) or an availability group (AG) in other places, what ties them together is the underlying Windows failover cluster (WSFC). Anyone who deploys FCIs or AGs needs a solid foundation of the entire clustering stack to truly be able to understand and have success with implementations. This session will demystify what lies underneath SQL Server from a DBA point of view.

3 things you'll get out of this session

Speaker

Allan Hirt's previous sessions

Business Continuity for Hybrid and Cloud Native SQL Server Deployments - 2023

Worst Practices for Highly Available SQL Server Deployments - 2023

Modern Infrastructure Fundamentals for SQL Server - 2022

Worst Practices for Highly Available SQL Server Deployments - 2022

Dealing with Bad Networks - The Availability Conundrum - 2022

So You Want to Be a Consultant? - 2022

Tips for Successful On Premises Virtual and IaaS Deployments of SQL Server - 2022

A Distributed Availability Groups Primer - 2020

Common Troubleshooting Techniques for AGs and FCIs - 2019

Storage Spaces Direct and Storage Replica for FCIs - 2018

Top 10 Clustering Dos and Dont's - 2017

SQL Server Clustering Basics for the DBA - 2016

Did You Vote Today? A DBAs Guide to Cluster Quorum - 2015

Clustering SQL Server: What Does It Mean In 2015? - 2015

SQL Server Storage vNext: Welcome to the Future - 2014

Patch Management Strategies for SQL Server Deployments - 2014

A Preview of High Availability in SQL Server 2012 - 2012

Multi-Site Failover Cluster With SQL 2008 and Denali - 2011

So Many High Availability Options, So Little Time - 2011