Clustering SQL Server 2012
WHAT’S IN THIS CHAPTER
- 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
- 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 ...