You're reading from SQL Server 2019 Administrator's Guide - Second Edition

Product type Book

Published in Sep 2020

Publisher Packt

ISBN-13 9781789954326

Pages 522 pages

Edition 2nd Edition

Languages

SQL

Concepts

Database Administration

Authors (2):

Marek Chmel

Vladimír Mužný

View More author details

Table of Contents (17) Chapters

Preface

1. Section 1: Provisioning the SQL Server Environment

2. Chapter 1: Setting Up SQL Server 2019

3. Chapter 2: Keeping Your SQL Server Environment Healthy

4. Section 2: Server and Database Maintenance

5. Chapter 3: Implementing Backup and Recovery

6. Chapter 4: Securing Your SQL Server

7. Chapter 5: Working with Disaster Recovery Options

8. Chapter 6: Indexing and Performance

9. Section 3: High Availability and the Cloud with SQL Server 2019

10. Chapter 7: Planning Migration and Upgrade

11. Chapter 8: Automation – Using Tools to Manage and Monitor SQL Server 2019

12. Chapter 9: Configuring Always On High Availability Features

13. Chapter 10: In-Memory OLTP – Why and How to Use it

14. Chapter 11: Combining SQL Server 2019 with Azure

15. Chapter 12: Taming Big Data with SQL Server

16. Other Books You May Enjoy

Leave a review - let other readers know what you think

Chapter 9: Configuring Always On High Availability Features

SQL Server high availability includes two main components called Always On Failover Cluster Instances and Always On Availability Groups. In this chapter, we will look at these two in depth and explore possible configurations for the SQL Server environment. Both features use Windows Server Failover Cluster (WSFC) functionality but have different methods of deployment.

WSFC is a server feature available on Windows Server, which allows the grouping of computers into a fault-tolerant cluster. In a case where one or more nodes fail, others will keep the service or application available.

Each Windows Server version brings new features to the WSFC feature and many of those can be beneficial for SQL Server deployment. Windows Server 2012 and 2012 R2 have brought many new enhancements and new features to WSFC, with a strong emphasis on the Hyper-V role used for virtualization. The main new features and improvements...