Formation : SQL 2016 AlwaysOn High Availability

Ref. 55246AC

Télécharger en PDF

Durée :

3

jours

Examen :

Non certifiant

Niveau :

Intermédiaire

Financement :

Temptraining

ITTA | Formations | Informatique | Analyse et bases de données | SQL 2016 AlwaysOn High Availability

Description

Cette formation est destinée aux administrateurs de bases de données et aux ingénieurs Windows afin de les familiariser avec les concepts de SQL AlwaysOn and High Availability. Le cours utilise SQL 2016 mais explique les différences entre SQL 2012 et SQL 2014.

Profils des participants

Les administrateur de base de données expérimentés
Les professionnels Windows Server
Les chefs d’équipe

Objectifs

Comprendre AlwaysOn High Availability
Utiliser Server 2016 Failover Clustering
Déployer SQL Failover Clusters
Travailler avec Availability Groups
Effectuer la maintenance
Surveiller et dépanner Availability Groups

Connaissances Préalables

Expérience en tant que administrateur de base de données SQL
Expérience en tant qu’IT PRO Windows

Contenu du cours

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

Support de cours numérique inclus

Lab / Exercices

Laboratoires en ligne

Cours complémentaires

Financement Temptraining

ITTA est partenaire de Temptraining, le fonds de formation continue pour les travailleurs temporaires. Ce fonds de formation peut subventionner des formations continues pour toute personne qui travaille pour un employeur assujetti à la Convention collective de travail (CCT) Location de services.