SQL Server AlwaysOn Revealed

SQL Server AlwaysOn Revealed

by Peter A Carter
Released December 2015
Publisher(s): Apress
ISBN: 9781484217634

Read it now on the O’Reilly learning platform with a 10-day free trial.

O’Reilly members get unlimited access to books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial

Book description

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
    •

    Table of contents

    1. Cover
    2. Title
    3. Copyright
    4. Dedication
    5. Contents at a glance
    6. Contents
    7. About the Author
    8. About the Technical Reviewers
    9. Chapter 1: High Availability and Disaster Recovery Concepts
      1. Level of Availability
        1. Service-Level Agreements and Service-Level Objectives
        2. Proactive Maintenance
      2. Recovery Point Objective and Recovery Time Objective
      3. Cost of Downtime
      4. Classification of Standby Servers
      5. Summary
    10. Chapter 2: Understanding High Availability and Disaster Recovery Technologies
      1. AlwaysOn Failover Clustering
        1. Active/Active Configuration
        2. Three-Plus Node Configurations
        3. Quorum
      2. Database Mirroring
      3. AlwaysOn Availability Groups
        1. Automatic Page Repair
      4. Log Shipping
        1. Recovery Modes
        2. Remote Monitor Server
      5. Combining Technologies
      6. Summary
    11. Chapter 3: Implementing a Cluster
      1. Building the Cluster
        1. Installing the Failover Cluster Feature
        2. Creating the Cluster
      2. Configuring the Cluster
        1. Changing the Quorum
        2. Configuring MSDTC
        3. Configuring a Role
      3. Summary
    12. Chapter 4: Implementing an AlwaysOn Failover Clustered Instance
      1. Building the Instance
        1. Preparation Steps
        2. Cluster-Specific Steps
        3. Installing the Instance with PowerShell
        4. Adding a Node
      2. Summary
    13. Chapter 5: Implementing AlwaysOn Availability Groups
      1. Implementing High Availability with AlwaysOn Availability Groups
        1. Configuring SQL Server
        2. Creating the Availability Group
        3. Performance Considerations for Synchronous Commit Mode
      2. Implementing Disaster Recovery with Availability Group
        1. Configuring the Cluster
        2. Configuring the Availability Group
      3. Adding AlwaysOn Readable Secondary Replicas
      4. Summary
    14. Chapter 6: Administering AlwaysOn
      1. Managing a Cluster
        1. Moving the Instance between Nodes
        2. Removing a Node from the Cluster
      2. Managing AlwaysOn Availability Groups
        1. Failover
        2. Synchronizing Uncontained Objects
        3. Monitoring
        4. Adding Multiple Listeners
        5. Other Administrative Considerations
      3. Summary
    15. Index

    Product information

    • Title: SQL Server AlwaysOn Revealed
    • Author(s): Peter A Carter
    • Release date: December 2015
    • Publisher(s): Apress
    • ISBN: 9781484217634