SQL Server AlwaysOn Revealed

verfasst von: Peter A Carter

Verlag: Apress

Enthalten in: Springer Professional "Wirtschaft+Technik" , Springer Professional "Technik" , Springer Professional "Wirtschaft"

Einloggen, um Zugang zu erhalten

Über dieses Buch

Get a fast start to using AlwaysOn, the SQL Server solution to high-availability and disaster recovery. Read this short, 150-page book that is adapted from Peter Carter’s Pro SQL Server Administration to gain a solid and accurate understanding of how to implement systems requiring consistent and continuous uptime.

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 concepts and terminology. Understand the technologies available, to implement HA and DR. Build and configure a Windows Cluster. Build and configure an AlwaysOn failover clustered instance. Implement AlwaysOn Availability Groups and appropriately configure them. Administer AlwaysOn technologies post implementation.

Who This Book Is For

SQL Server AlwaysOn Revealed is for database administrators interested in growing their knowledge and skills in Microsoft SQL Server’s high-availability and disaster recovery feature set.

Inhaltsverzeichnis

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 discuss 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

Once the cluster has been built and configured, it is time to install the AlwaysOn failover cluster instance of SQL Server. This chapter will discuss how to create an AlwaysOn Failover Clustered Instance and also demonstrate how to add a node to the cluster.

Peter A Carter

Chapter 5. Implementing 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. 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 monitoring with the AlwaysOn Dashboard and a demonstration of how to failover.

Peter A Carter

Backmatter

Titel: SQL Server AlwaysOn Revealed
verfasst von: Peter A Carter
Verlag: Apress
Electronic ISBN: 978-1-4842-1763-4
Print ISBN: 978-1-4842-1762-7
DOI: https://doi.org/10.1007/978-1-4842-1763-4