Instructor-led training
Microsoft SQL AlwaysOn and High Availability for SQL 2016 Training in Atwater, California
This two or three day instructor-led course is designed for database administrators and Windows engineers to familiarize them with the concepts in SQL AlwaysOn and High Availability.
What you'll learn
This two or three day instructor-led course is designed for database
administrators and Windows engineers to familiarize them with the
concepts in SQL AlwaysOn and High Availability. The course utilizes SQL
2016, but explains the differences from SQL 2012- SQL 2014. For skills
to be transferred this is a lab intense course. It is designed for the
student to understand the the reason for the lab and how they can use
those skills.
Prerequisites
This course is intended for SQL DBAs and IT Professionals. It is highly
recommended that each company attending the course send both DBAs and
Windows Engineers as the High Availability functionality crosses both disciplines.
Course Outline
MODULE 1: COURSE OVERVIEW
This module explains how the class will be structured and introduces course materials and additional administrative information
Introduction
Course Materials
Facilities
Prerequisites
What We'll Be Discussing
Lab 1: COURSE OVERVIEW
After completing this module, students will be able to:
Successfully log into their virtual machine.
Have a full understanding of what the course intends to cover.
MODULE 2: ALWAYSON AND HIGH AVAILABILITY CONCEPTS AND TERMINOLOGY
In this module, we will examine the evolution of PowerShell, explore the interfaces of both the console and the PowerShell ISE, and cover utilizing the help system.
Concepts and Terminology
Edition Changes from SQL 2012 and SQL 2014
Failover Clusters
Log Shipping
Replication
Database Mirroring
Database Snapshots
Limitations of prior solutions
What’s new in SQL 2016 Always on High Availability
Lab 1: ALWAYSON AND HIGH AVAILABILITY CONCEPTS AND TERMINOLOGY
MODULE 3: ALWAYSON AVAILABILITY GROUPS
In this module, we will discuss SQL failover cluster implementation, multi-site clustering, and explain the flexible failover policy provided with SQL Server AlwaysOn.
Concepts
Availability Groups and Replicas
Listener
Availability Mode
Failover Mode
Topologies
Data Synchronization
Flexible Failover Policy
Lab 1: ALWAYSON
MODULE 4 WINDOWS SERVER 2016 FAILOVER CLUSTERING
In this module, we will cover the Windows Server 2016 Failover Clustering.
Understanding Failover Clustering in Server 2016
Cluster Nodes
Resources
Dependencies
Failover/Failback
Owners
Heartbeat
Group Managed Service Accounts
Lab: Creating a Windows Server 2016 Cluster
MODULE 5: UNDERSTANDING QUORUMS
Quorums determine the number of failures that a cluster can sustain, and if additional failures occur, the cluster will stop running. In this module, we discuss how to configure the quorum, and explain the options available.
Node Majority
Node and Disk Majority
Node and File Share Majority
No Majority
Dynamic Quorum
Dynamic Witness
Lab 1: UNDERSTANDING QUORUMS
Implement a Quorum
MODULE 6: SQL 2016 ALWAYSON AVAILABILITY GROUPS
SQL Server AlwaysOn Availability Groups provide us the capability to group two or more databases and perform a failover of both as a logical unit. In this module, we will explore how to configure and utilize Availability Groups.
Application Failover
Availability Group (AG)
Distributed Transaction Coordinator (DTC)
Availability Replica
Synchronous Replica
Asynchronous Replica
Optimized Log Transport
Lab 1: ALWAYSON AVAILABILITY GROUPS
Enable AlwaysOn in SQL Server
Testing Failover Cluster and Adding Sample Databases
Create the High Availability Group
Add Replica and Listener
MODULE 7: ACTIVE SECONDARY AVAILABILITY GROUP ACTIONS
In AlwaysOn Availability Groups, an active secondary can be used for things like redirecting the read-only workload, off-loading the backup load, and other tasks. In this module, we discuss how an active secondary replica operates, and explore a few tasks that can be tackled using a secondary.
Load Balancing
Active Secondary Replicas
Readable Secondary Replicas
Backups on Secondary Replicas
Lab 1: SECONDARY AVAILABILITY GROUP ACTIONS
MODULE 8: MONITORING AND MAINTENANCE
In this module, we will explain monitoring AlwaysOn Availability Groups, explore and utilize the Dashboard, and discuss troubleshooting tools.
Suspend Secondary Database Synchronization
Suspend Primary Database Synchronization
Resume Synchronization
Add\Remove a Database
Add\remove a Replica
Index Maintenance
Dashboard
Policy Based Management
Reports and Logs
Lab 1: MONITORING AND MAINTENANCE
Suspend Secondary Database Synchronization
Suspend Primary Database Synchronization
Resume Synchronization
Add\Remove a Database
Add\remove a Replica
Index Maintenance
Dashboard
Policy Based Management
Reports and Logs
Module 9: Using Microsoft Azure Availability Groups
Concepts
Availability Groups in Microsoft Azure
Training locations
Microsoft SQL AlwaysOn and High Availability for SQL 2016 training across the U.S. and beyond.
We provide Microsoft SQL AlwaysOn and High Availability for SQL 2016 training onsite and live online for organizations throughout the United States and internationally.
View all Microsoft SQL AlwaysOn and High Availability for SQL 2016 training locations
Train your team with HSG
Private, instructor-led training customized for your organization.
- Onsite or live online delivery
- Customized curriculum
- Training for groups of 3 or more
- Flexible scheduling
- Experienced instructors
Questions? Call us at 303.377.6176
or email info@hartmannsoftware.com
Related training
Browse all Microsoft SQL Server courses →
Ready to train your team?
Let's customize this training for your organization.
Tell us about your employees, your goals, and your preferred schedule. We'll prepare a training proposal covering scope, delivery format, and pricing.