Training: SQL 2016 AlwaysOn High Availability (55246)

Ref. 55246AC

Download PDF

Duration:

3

days

Exam:

Not certifying

Level:

Intermediate

Funding:

Temptraining

Home > Trainings > IT Pro > Analytics and Data Management > SQL 2016 AlwaysOn High Availability (55246)

SQL 2016 AlwaysOn High Availability Training

Optimize Your SQL Server Infrastructure with Our Advanced AlwaysOn and High Availability Training

This SQL 2016 AlwaysOn High Availability training is designed for database administrators and Windows engineers, immersing you in the advanced concepts of SQL AlwaysOn and High Availability.

Using SQL 2016, you will learn to deploy failover clusters, configure availability groups, and perform proactive maintenance. Join us to master best practices for monitoring and troubleshooting availability groups while integrating key differences between SQL 2012, SQL 2014, and SQL 2016. Elevate your skills and ensure maximum availability of your SQL systems.

Participant profiles

Experienced DBAs
Windows Server Pros
Team leaders

Objectives

Understand AlwaysOn High Availability
Employ Server 2016 Failover Clustering
Deploy SQL Failover Clusters
Work with Availability Groups
Perform maintenance
Monitor and Troubleshoot Availability Groups

Prerequisites

Experience as SQL DBA
Experience as Windows IT PRO

Course content

Module 01: Introduction

Course introduction

Module 02: Alwayson and high availability concepts and terminology

Concepts and Terminology
Table of Availability
High Availability
Causes of Downtime
Planned downtime
Unplanned downtime
Disaster Recovery
Recovery Time Objective (RTO)
Recovery Point Objective (RPO)
Recovery Level Objective (RLO)
Storage Area Networks (SAN)
Edition Changes from SQL 2012
SQL Server 2014 Changes
SQL Server 2016 Changes
Legacy Solutions prior to Always On
Failover Cluster Instances
Log Shipping
A Typical Log Shipping Configuration
Monitor Server
Replication
Database Mirroring
Database Mirroring Terminology
Principle
Mirror
Witness (red box in image above)
Database Snapshots
Limitations of legacy solutions:
What do we mean by Always On?
Table of Always On Comparison

Module 03: Windows server 2016 failover clustering

Understanding Failover Clustering in Server 2016
Statefull High Availability Solution
Supported in both Standard and Datacenter
Servers should run similar hardware
Should run same edition
Hyper-V best with datacenter
Certified for Windows server logo
Shared Storage
Quorums
Node Majority
Node and Disk Majority configuration:
Node and File Share Majority
No Majority
Configuration
Cluster Networks Best Practices
Connection to nodes to shared storage
Private network for internal cluster
Public network for client connections
Cluster Aware Updating
Virtual Machine Failover Clustering
Preferred Owners
Failover Failback
Resources
Dependences
Heartbeat

Module 04: SQL 2016 failover cluster instances

Failover Cluster Instance
As A FCI Appears To A Client

Module 05: SQL 2016 alwayson availability groups

Availability Groups and Replicas
Primary Replica
Secondary Replicas
Availability Group Listener
Availability Mode
Synchronous Commit Mode
Asynchronous Commit Mode
Failover Modes
Automatic Failover Without Data Loss
Automatic Failover Requirements:
Manual
Manual Failover Requirements
Common Topologies

Module 06: The Dasboard

The Dashboard
How to view logs
Using replication with Logins
Using partially contained databases

Module 07: Active Secondary Availability Group Actions

Reporting with Secondary Replicas
Configuring a Readable secondary
Read-Only Routing
Load Balancing
Lab : Configure a Read-Only Secondary
Database Backups with Secondary
Steps of Backup Using secondary
Backup Preference Options

Module 08: Maintenance

DBCC Checks
Database Adding and Removing

Module 09: Monitoring and troubleshooting availibility groups

The Dashboard in Depth
Events
Policy Based Managemnt for Availability Groups

Documentation

Digital courseware included

Lab / Exercises

Online Labs

Complementary courses

Temptraining funding

ITTA is a partner of Temptraining, the continuing education fund for temporary workers. This training fund can subsidize continuing education for anyone who works for an employer subject to the Collective Work Agreement (CCT) Rental of services.

Additional information

SQL 2016 AlwaysOn High Availability Training (55246)

Our training “SQL Server 2016: High Availability and AlwaysOn” provides you with an in-depth understanding of high availability concepts and AlwaysOn technologies for SQL Server. Discover the essential terminologies, availability tables, and the various causes of downtime, including planned and unplanned interruptions.

Effective high availability management involves a thorough knowledge of disaster recovery. We will cover crucial concepts such as the Recovery Time Objective (RTO), the Recovery Point Objective (RPO), and the Recovery Level Objective (RLO). You will also understand the importance of Storage Area Networks (SAN) and the edition changes in SQL Server since 2012, with a focus on the 2014 and 2016 versions.

Windows Server 2016 Failover Clustering

In this section, delve into failover clustering in Windows Server 2016, a robust high availability solution for SQL Server. Learn to configure failover clusters on similar hardware and the same server edition, optimized for Hyper-V with Datacenter.

Explore best practices for cluster networks, including connecting nodes to shared storage, private networks for internal clustering, and public networks for client connections. You will also learn to configure quorums, node and disk majority configurations, and implement cluster-aware updates.

SQL 2016 Failover Cluster Instances

Discover Failover Cluster Instances (FCI) in SQL Server 2016. Learn how an FCI instance appears to a client and how these instances can ensure high availability for your critical databases.

SQL 2016 AlwaysOn Availability Groups

AlwaysOn Availability Groups are an advanced feature of SQL Server 2016 for ensuring high availability. Discover how to configure primary and secondary replicas, use availability group listeners, and the different availability modes, including synchronous and asynchronous commit modes.

We will also cover failover modes, the requirements for automatic failover without data loss, and common topologies for implementing availability groups. Ensure your SQL Server infrastructure is always ready to meet your business needs.

The Dashboard

The SQL Server dashboard is an essential tool for monitoring and managing your SQL Server environments. Learn to view logs, use replication with connections, and manage partially contained databases. Maximize the efficiency and performance of your SQL Server with a well-configured dashboard.

Active Secondary Availability Group Actions

Explore the possible actions with active secondary replicas in SQL Server. Discover how to configure a readable secondary replica for reporting, read-only routing, and load balancing. Learn also to perform database backups using secondary replicas, with backup preference options.

Maintenance

Regular maintenance is crucial for the health of your SQL Server databases. Learn to perform DBCC checks and safely add or remove databases. Keep your SQL Server in perfect working condition with optimized maintenance practices.

Monitoring and Troubleshooting Availability Groups

Finally, the training focuses on monitoring and troubleshooting availability groups in SQL Server. Delve deeply into the dashboard, relevant events, and policy-based management to ensure high availability for your databases. Keep your SQL Server performing at its best by mastering monitoring and troubleshooting techniques.