O'Reilly logo

Professional Microsoft SQL Server 2014 Administration by Brian Knight, Ross LoForte, Steven Wort, Bradley Ball, Adam Jorgensen

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 16Clustering SQL Server 2014

WHAT'S IN THIS CHAPTER?

  • 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.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required