DeepDive High Availability - AlwaysOn Availability Groups
Improved in SQL Server 2016
Duration: 8 hours
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
WHEN and WHERE is this course running?
- SQL Server AG configuration
- Read Only Routing and Load Balancing
- Direct seeding
- Distributed AG
- Adding/Removing files to/from database in AG
- Adding/Removing database to/from AG