Skip to main content
Disciplines
Automotive Business IT + Informatics Construction + Real Estate Electrical Engineering + Electronics Energy + Sustainability Insurance + Risk Finance + Banking Management + Leadership Marketing + Sales Mechanical Engineering + Materials
Events
DE
EN
Books
Journals
Topic Page
Marketing
Start single access now
Access for companies
EXTENDED SEARCH
Log in
Top

2016 | Book

High Availability and Disaster Recovery Concepts Read chapter Read first chapter

SQL Server AlwaysOn Revealed

Author: Peter A. Carter

Publisher: Apress

Part of: Springer Professional "Wirtschaft+Technik" , Springer Professional "Technik" , Springer Professional "Wirtschaft"

Login to get access
insite
SEARCH

About this book

Get a fast start to using AlwaysOn, the SQL Server solution to high-availability and disaster recovery. This second edition is newly-updated to cover the 2016 editions of both SQL Server and Windows Server. Also in this edition is all-new content on troubleshooting and metadata. The book provides a solid and accurate understanding of how to implement systems requiring consistent and continuous uptime, as well as how to troubleshoot those systems in order to keep them running an reliable.

Begin with an introduction to high-availability and disaster recovery concepts such as Recovery Point Objectives (RPOs), Recovery Time Objectives (RTO), availability levels, and the cost of downtime. Then move into detailed coverage of implementing and configuring the AlwaysOn feature set in order to meet the business objectives set by your organization.

SQL Server AlwaysOn Revealed offers real-world advice on how to build and configure the most appropriate topology to meet the high-availability and disaster recovery requirements you are faced with. Content includes strong coverage on implementing clusters, on building AlwaysOn failover clustered instances, and on configuring AlwaysOn Availability Groups. This is a practical and hand-on book to get you started quickly in using one of the most talked-about SQL Server feature sets.

Teaches you to build HA and DR solutions using the AlwaysOn feature set Provides real-world advice on configuration and performance considerations Demonstrates administrative techniques for the AlwaysOn feature set

What You Will Learn

Understand high availability and disaster recovery in SQL Server 2016 Build and configure a Windows Cluster

Create and configure an AlwaysOn failover clustered instance Implement AlwaysOn Availability Groups and appropriately configure themAdminister AlwaysOn technologies post implementationTroubleshoot and resolve problems with misbehaving systems

Who This Book Is For

Database administrators interested in growing their knowledge and skills in Microsoft SQL Server’s high-availability and disaster recovery feature set.

Table of Contents

Frontmatter
Chapter 1. High Availability and Disaster Recovery Concepts
Abstract
In today’s 24×7 environments that are running mission-critical applications, businesses rely heavily on the availability of their data. Although servers and their software are generally reliable, there is always the risk of a hardware failure or a software bug, each of which could bring a server down. To mitigate these risks, business-critical applications often rely on redundant hardware to provide fault tolerance. If the primary system fails, then the application can automatically fail over to the redundant system. This is the underlying principle of high availability (HA).
Peter A. Carter
Chapter 2. Understanding High Availability and Disaster Recovery Technologies
Abstract
SQL Server provides a full suite of technologies for implementing high availability and disaster recovery. This chapter provides an overview of these technologies and discusses their most appropriate uses.
Peter A. Carter
Chapter 3. Implementing a Cluster
Abstract
Engineers may find the process of building and configuring a cluster to be complex and that they can implement many variations of the pattern. Although DBAs may not always need to build a cluster themselves, they do need to be comfortable with the technology and often need to provide their input into the process. They may also take part in troubleshooting issues discovered with the cluster.
Peter A. Carter
Chapter 4. Implementing an AlwaysOn Failover Clustered Instance
Abstract
We will also discuss how to build the failover clustered instance using PowerShell. To do this, we will need to use the Install a SQL Server Failover Cluster wizard on the primary node of the cluster. We will then need to run the Add Node wizard, to allow the passive node to host the instance in the event of a failover.
Peter A. Carter
Chapter 5. Implementing HA with AlwaysOn Availability Groups
Abstract
AlwaysOn Availability Groups provide a flexible option for achieving high availability, recovering from disasters, and scaling out read-only workloads. The technology synchronizes data at the database level, but health monitoring and quorum are provided by a Windows cluster.
Peter A. Carter
Chapter 6. Implementing DR with AlwaysOn Availability Groups
Abstract
In Chapter 5, we successfully implemented high availability for the App1Customers and App1Sales databases through the App1 availability group. In this chapter, we will discuss how we can also implement disaster recovery for these databases. To do this, we first need to build out a new server in our second site and install a stand-alone instance of SQL Server. Because the cluster now spans two sites, we need to reconfigure it as a multi-subnet cluster. We also need to reconfigure the quorum model to remove its dependency on the shared storage, which we currently have for the quorum. Once this is complete, we are able to add the instance on the new node to our availability group. The following sections assume that you have already built out a third server with a SQL Server instance called CLUSTERNODE3\ASYNCDR, and they demonstrate how to reconfigure the cluster as well as the availability group.
Peter A. Carter
Chapter 7. Administering AlwaysOn
Abstract
This chapter will discuss how to administer AlwaysOn features. We will first look at cluster maintenance, including rolling patch upgrades and removing an instance. We will then discuss managing Availability Groups, including how to fail over synchronously and asynchronously. We will also examine how to fail over a Distributed Availability Group.
Peter A. Carter
Chapter 8. Monitoring AlwaysOn Availability Groups
Abstract
Once you have implemented Availability Groups, you need to monitor them and respond to any errors or warnings that could affect the availability of your data. If you have many availability groups implemented throughout the enterprise, then the only way to monitor them effectively and holistically is by using an enterprise monitoring tool, such as SOC (Systems Operations Center). If you only have a small number of availability groups, however, or if you are troubleshooting a specific issue, then SQL Server provides the AlwaysOn Dashboard and the AlwaysOn Health Trace. You can also create your own Extended Events sessions to monitor Availability Groups. This chapter will discuss each of these monitoring possibilities.
Peter A. Carter
Chapter 9. Troubleshooting AlwaysOn
Abstract
SQL Server exposes a wealth of metadata, pertaining to high availability and disaster recovery objects, especially around the AlwaysOn feature set. This metadata can be used to quickly identify a configuration, find the root cause of an issue, or script automated responses to events that may occur. The following sections will discuss the metadata that is available, and provide examples of how it can be used.
Peter A. Carter
Backmatter
Metadata
Title
SQL Server AlwaysOn Revealed
Author
Peter A. Carter
Copyright Year
2016
Publisher
Apress
Electronic ISBN
978-1-4842-2397-0
Print ISBN
978-1-4842-2396-3
DOI
https://doi.org/10.1007/978-1-4842-2397-0

Premium Partner

    Image Credits