SQL Server AlwaysOn Revealed

1. Auflage 2015
ISBN: 978-1-4842-1762-7
Verlag: Apress

Buch, Englisch, 150 Seiten, Format (B × H): 178 mm x 254 mm, Gewicht: 332 g

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.

Zielgruppe

Professional/practitioner

Autoren/Hrsg.

Carter, Peter A.

Fachgebiete

• Mathematik | Informatik EDV | Informatik Programmierung | Softwareentwicklung Datenbankprogrammierung SQL Server/MS SQL

Inhaltsverzeichnis

Chapter 1: HA and DR ConceptsLearn the concepts and terminology behind high availability and disaster recovery. - Level of Availability

- Recovery Point Objective and Recovery Time Objective

- Cost of Downtime

- Classification of Standby Servers

Chapter 2: Understanding HA and DR TechnologiesGain understanding of the various technologies that can be leveraged to obtain high availability and disaster recovery for their data-tier applications. - AlwaysOn Failover Clustering

- Database Mirroring

- AlwaysOn Availability Groups

- Log Shipping

- Combining Technologies

Chapter 3: Implementing a ClusterImplement and configure a Windows failover cluster using Windows Server 2012 R2. The cluster will form the base to support either an AlwaysOn Failover Clustered Instance or AlwaysOn Availability Groups. - Building the Cluster

- Configuring the Cluster

Chapter 4: Implementing an AlwaysOn Failover Clustered InstanceLearn the differences between building a stand-alone instance and building an AlwaysOn Failover Clustered Instance. Also learn to add a node to an existing AlwaysOn Failover Clustered Instance. - Building the Instance

- Adding a Node

Chapter 5: Implementing AlwaysOn Availability GroupsImplement AlwaysOn Availability Groups for the purposes of both high availability and disaster recovery. Gain an insight into the impact synchronous Availability Groups can have on performance. - Implementing High Availability with AlwaysOn Availability Groups

- Implementing Disaster Recovery with AlwaysOn Availability Groups

Adding AlwaysOn Readable Secondary Replicas

Chapter 6: Administering AlwaysOnPerform important administration tasks against AlwaysOn Availability Groups. Fail over to other nodes as needed, and monitoring ongoing operations. Also perform maintenance tasks against clusters, such as applying rolling patch upgrades and removing nodes. - Managing a Cluster

- Managing AlwaysOn Availability Groups

Über Autor(innen)

Peter Carter is a SQL Server expert with over a decade of experience in developing, administering, and architecting SQL Server platforms and data-tier applications. Peter was awarded an MCC by Microsoft in 2011, and it sits alongside his array of MCTS, MCITP, MCSA and MCSE certifications in SQL Server from version 2005 onward. His passion for SQL Server shows through in everything he does, and his goal is that his passion for the technology will inspire others.