Chapter 16

Clustering SQL Server 2012


  • Identifying Clustering and Mastering its Intricacies
  • Researching Hardware and Software Configurations to Identify What Works Best for your Organization
  • Configuring Hardware
  • Configuring and then Clustering the Operating System
  • Configuring SQL Server 2012 on the Cluster
  • Testing
  • Documenting
  • Administering and Troubleshooting the Production SQL Server 2012 Cluster

Unlike most aspects of the DBA’s job, the task of installing, configuring, and administering a clustered SQL Server can be an adventure, complete with excitement, danger, and an uncertain outcome. But with this chapter’s tried-and-true information, you can successfully install, configure, and administer a clustered instance of SQL Server 2012. In this chapter, you learn how a Windows Failover Cluster works and whether it’s the right solution for your organization. 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 a SQL Server 2012 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 2008, this chapter primarily focuses on co-located clustering as well as the most commonly deployed Windows Failover Cluster configuration.

If you don’t have Storage Area ...

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

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