September 2014
Intermediate to advanced
936 pages
25h 44m
English
book
Professional Microsoft SQL Server 2014 Administration
by Adam Jorgensen, Bradley Ball, Steven Wort, Ross LoForte, Brian Knight
Content preview from Professional Microsoft SQL Server 2014 Administration
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
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.
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access
More than 5,000 organizations count on O’Reilly
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.Julian F.
I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.Addison B.
I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.Amir M.
I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.