Chapter 16Clustering SQL Server 2014


  • Getting to know clustering and mastering its intricacies
  • Researching hardware and software configurations to identify what works best for your organization
  • Configuring hardware
  • Configuring and clustering the operating system
  • Configuring SQL Server 2014 on the cluster
  • Testing the installation
  • Administering and troubleshooting the production SQL Server 2014 cluster

With this chapter's tried-and-true information, you can successfully install, configure, and administer a clustered instance of SQL Server 2014. In this chapter, you learn how a Windows Failover Cluster Instance (FCI) works, and whether it's the right solution for your organization. The newly adopted name is AlwaysOn Failover Cluster Instance as of SQL Server 2012, which is synonymous with Windows Server Failover Cluster. You learn how to choose between upgrading a previous version of a Windows Failover Cluster and building a new cluster; how to plan for clustering, including hardware and the operating system; and how to install SQL Server 2014 on a Windows Failover Cluster. Finally, you learn how to maintain and troubleshoot an operational instance of SQL Server on a cluster.

Although you can deploy a geographically dispersed cluster in Windows 2012 R2, this chapter primarily focuses on co-located clustering, as well as the most commonly deployed Windows Failover Cluster configuration.

Get Professional Microsoft SQL Server 2014 Administration now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.