SQL Server Administration and Maintenance

SQH04 A Lap Around Multi-Site Clustering for SQL Server DBAs


9:30am - 10:45am

Level: Intermediate to Advanced

Edwin Sarmiento

Managing Director


Deploying a Windows Server Failover Cluster (WSFC) on Windows Server 2008/2012 has become a lot easier thanks to numerous online resources. And with more advanced features in WSFC, it is now both a high availability and disaster recovery solution for SQL Server databases—whether using failover clustered instances or Availability Groups. In this session, you'll learn the underlying concepts and principles when designing a multi-subnet cluster to address both high availability and disaster recovery requirements. After this session, you'll be able to properly design a multi-subnet WSFC stretched across multiple data centers that meet your overall recovery objectives.

You will learn:

  • About network considerations when designing a multi-subnet cluster
  • WSFC dependencies that are outside the scope of the SQL Server database but impacts the availability
  • How to properly design and deploy a multi-subnet cluster for both failover clustered instances and Availability Groups