This two-day instructor-led course is designed for database administrators to familiarize them with the concepts in SQL AlwaysOn and High Availability. The course utilizes SQL 2014, but explains the differences from SQL 2012.
-
- Horário
-
Laboral
das 09h30 às 17h30
-
- Local
- Live Training
-
- Calendário
- 20 Dez. 2021 a 21 Dez. 2021
Destinatários
This course is intended for SQL DBAs and IT Professionals.
Objetivos
- Understand and utilize AlwaysOn and high availability concepts and terminology.
- Understand edition changes from SQL 2012.
- Understand failover clusters.
Programa
- Course Overview
- AlwaysOn and High Availability Concepts and Terminology
- AlwaysOn
- Understanding Quorums
- AlwaysOn Availability Groups
- Secondary Availability Group Actions
- Monitoring
Course Overview
- Introduction
- Course Materials
- Facilities
- Prerequisites
- Course Overview
Lab : Course Overview
AlwaysOn and High Availability Concepts and Terminology
- Concepts and Terminology
- Edition Changes from SQL 2012
- Failover Clusters
- Log Shipping
- Replication
- Database Mirroring
- Database Snapshots
Lab : AlwaysOn and High Availability Concepts and Terminology
AlwaysOn
- SQL Failover Cluster Implementation
- Multi-Site Clustering
- Flexible Failover Policy
Lab : AlwaysOn
Understanding Quorums
- Node Majority
- Node and Disk Majority
- Node and File Share Majority
- No Majority
- Configuration
Lab : Understanding Quorums
AlwaysOn Availability Groups
- Application Failover
- Availability Group (AG)
- Availability Replica
Lab : AlwaysOn Availability Groups
Secondary Availability Group Actions
- Active Secondary Replicas
- Readable Secondary Replicas
- Backups on Secondary Replicas
Lab : Secondary Availability Group Actions
Monitoring
- Monitoring AlwaysOn Availability Groups
- Dashboard
- Troubleshooting Tools
Lab : Monitoring