Global - (+34) 91 414 89 50 | N. America - (800) 757 6543

DeepDive High Availability - AlwaysOn Availability Groups

Improved in SQL Server 2016


Duration: 8 hours


Level: 300


What does this course cover?

For Availability Groups are more attractive for some companies compare to Failover Clustering especially those who also have Disaster Recovery in mind. In SQL Server 2016, there was removed a huge amount of limitations from the previous versions, which allows secondary replicas to achieve 90-95% of performance of primary replica and also make AG more manageable as in 2012/2014.

Pre-requisites: What do you need to know?

Experience with SQL Server and Windows Server Administration

“All you want to know about AG in a very compact form”

Gael de Winters

Head of Infrastructure & Databases, Brussels

Course outline

Key Topics:
  • SQL Server AG configuration
    • Sync/Async
    • Read Only Routing and Load Balancing
    • Direct seeding
    • Distributed AG
  • Maintenance
    • Patching/Upgrading
    • Adding/Removing files to/from database in AG
    • Adding/Removing database to/from AG
  • Monitoring
  • Troubleshooting

All our courses can be offered as a private delivery and tailored for your team's specific needs