SQL SERVER 2019 ALWAYS ON : supporting 24x7 applications with continuous uptime.

Table of Contents 5 About the Author 9 About the Technical Reviewer 10 Acknowledgments 11 Introduction 12 Chapter 1: High Availability and Disaster Recovery Concepts 13 Level of Availability 13 Actual Availability 16 Service-Level Agreements and Service-Level Objectives 17 Proactive Maintenance 17 Recovery Point Objective and Recovery Time Objective 18 Cost of Downtime 19 Classification of Standby Servers 20 Summary 21 Chapter 2: Understanding High Availability and Disaster Recovery Technologies 23 AlwaysOn Failover Clustering 23 Active/Active Configuration 25 Three-Plus Node Configurations 26 Quorum 28 AlwaysOn Availability Groups 30 Automatic Page Repair 35 Log Shipping 36 Recovery Modes 37 Remote Monitor Server 38 Failover 39 Combining Technologies 39 Summary 42 Chapter 3: Implementing a Cluster 43 Building the Cluster 45 Installing the Failover Cluster Feature 45 Creating the Cluster 52 Configuring the Cluster 63 Changing the Quorum 63 Advanced Quorum Configuration 67 Configuring MSDTC 72 Configuring a Role 76 Summary 78 Chapter 4: Implementing an AlwaysOn Failover Clustered Instance 80 Building the Instance 80 Installing the Instance with PowerShell 99 Adding a Node 101 Adding a Node Using PowerShell 104 Summary 106 Chapter 5: Implementing AlwaysOn Availability Groups On Windows 107 Preparing to Implement AlwaysOn Availability Groups 108 Configuring SQL Server 116 Using the New Availability Group Wizard 118 Using the New Availability Group Dialog Box 129 Using T-SQL 136 Implementing Availability Groups with PowerShell 141 Summary 144 Chapter 6: Implementing AlwaysOn Availability Groups On Linux 145 Linux Cluster Technologies 146 Pcs 146 Pacemaker 146 Corosync 147 STONITH 147 Preparing to Implement AlwaysOn Availability Groups 147 Enable Availability Groups 148 Create the Sales Database 148 Create the Certificates 150 Configuring the Availability Group 152 Configuring the Cluster 157 Summary 163 Chapter 7: Atypical Availability Group Implementations 164 Basic Availability Groups 164 Availability Groups on Azure IaaS 166 Azure Availability Concepts 166 Availability Sets 166 Availability Zones 167 Regions 167 Implementing Availability Groups in Azure 167 Creating an Availability Set 168 Create Availability Groups on Azure VMs 170 Create the VMs 171 Configuring the Availability Group 180 Clusterless Availability Groups 190 Preparing the Instances 191 Enable Availability Groups 191 Create the Customers Database 192 Create Logins 195 Create and Configure the Availability Group 196 Domain-Independent Availability Groups 198 Preparing for the Cluster 199 Create the Cluster 200 Preparing for the Availability Group 200 Distributed Availability Groups 203 Summary 205 Chapter 8: Administering AlwaysOn 207 Managing a Cluster 207 Moving the Instance Between Nodes 207 Rolling Patch Upgrade 209 Removing a Node from the Cluster 211 Managing AlwaysOn Availability Groups 213 Failover 213 Synchronous Failover 213 Asynchronous Failover 216 Failing Over a Distributed Availability Group 219 Synchronizing Uncontained Objects 221 Adding Multiple Listeners 221 Other Administrative Considerations 224 Summary 226 Chapter 9: Monitoring AlwaysOn Availability Groups 227 AlwaysOn Dashboard 227 AlwaysOn Health Trace 230 Monitoring AlwaysOn with Extended Events 232 Extended Events Concepts 232 Packages 232 Events 233 Targets 242 Actions 243 Predicates 243 Types 244 Maps 244 Sessions 245 Creating an Event Session to Monitor Availability Group 245 Summary 252 Chapter 10: Troubleshooting AlwaysOn 253 AlwaysOn Failover Clustered Instance Metadata 253 Discovering the Node That Hosts an Instance 253 Viewing Health Check Configuration 255 AlwaysOn Availability Group Metadata 259 Determining the Last Failover Reason 259 Assessing the State of Availability Databases 262 Summary 268 Index 269 Get a fast start to using AlwaysOn, the SQL Server solution to high-availability and disaster recovery. This third edition is newly-updated to cover the 2019 editions of both SQL Server and Windows Server and includes strong coverage of implementing AlwaysOn Availability Groups on both Windows and Linux operating systems. 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 and reliable. This edition is updated to account for all new major functionality and also includes coverage of implementing atypical configurations, such as clusterless and domain-independent Availability Groups, distributed Availability Groups, and implementing Availability Groups on Azure.The book begins with an introduction to high-availability and disaster recovery concepts such as Recovery Point Objectives (RPOs), Recovery Time Objectives (RTOs), availability levels, and the cost of downtime. You’ll then move into detailed coverage of implementing and configuring the AlwaysOn feature set in order to meet the business objectives set by your organization. Content includes coverage on implementing clusters, building AlwaysOn failover clustered instances, and configuring AlwaysOn Availability Groups.SQL Server 2019 AlwaysOn is chock full of 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, as well as how to use AlwaysOn Availability Groups to scale-out read-only workloads. This is a practical and hands-on book to get you started quickly in using one of the most talked-about SQL Server feature sets.What You Will Learn* Understand high availability and disaster recovery in SQL Server 2019* Build and configure a Windows Cluster in Windows Server 2019* Create and configure an AlwaysOn failover clustered instance* Implement AlwaysOn Availability Groups and appropriately configure them* Implement AlwaysOn Availability Groups on Linux servers* Configure Availability Groups on Azure IaaS* Administer AlwaysOn technologies post implementation* Understand typical configurations, such as clusterless and distributed Availability GroupsWho This Book Is ForFor Microsoft SQL Server database administrators who interested in growing their knowledge and skills in SQL Server’s high-availability and disaster recovery feature set. Get A Fast Start To Using Alwayson, The Sql Server Solution To High-availability And Disaster Recovery. This Third Edition Is Newly-updated To Cover The 2019 Editions Of Both Sql Server And Windows Server And Includes Strong Coverage Of Implementing Alwayson Availability Groups On Both Windows And Linux Operating Systems. 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 And Reliable. This Edition Is Updated To Account For All New Major Functionality And Also Includes Coverage Of Implementing Atypical Configurations, Such As Clusterless And Domain-independent Availability Groups, Distributed Availability Groups, And Implementing Availability Groups On Azure. The Book Begins With An Introduction To High-availability And Disaster Recovery Concepts Such As Recovery Point Objectives (rpos), Recovery Time Objectives (rtos), Availability Levels, And The Cost Of Downtime. You’ll Then Move Into Detailed Coverage Of Implementing And Configuring The Alwayson Feature Set In Order To Meet The Business Objectives Set By Your Organization. Content Includes Coverage On Implementing Clusters, Building Alwayson Failover Clustered Instances, And Configuring Alwayson Availability Groups. Sql Server 2019 Alwayson Is Chock Full Of 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, As Well As How To Use Alwayson Availability Groups To Scale-out Read-only Workloads. This Is A Practical And Hands-on Book To Get You Started Quickly In Using One Of The Most Talked-about Sql Server Feature Sets. What You Will Learn Understand High Availability And Disaster Recovery In Sql Server 2019 Build And Configure A Windows Cluster In Windows Server 2019 Create And Configure An Alwayson Failover Clustered Instance Implement Alwayson Availability Groups And Appropriately Configure Them Implement Alwayson Availability Groups On Linux Servers Configure Availability Groups On Azure Iaas Administer Alwayson Technologies Post Implementation Understand Typical Configurations, Such As Clusterless And Distributed Availability Groups Who This Book Is For For Microsoft Sql Server Database Administrators Who Interested In Growing Their Knowledge And Skills In Sql Server’s High-availability And Disaster Recovery Feature Set.