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
“All you want to know about AG in a very compact form”Gael de Winters
- 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
All our courses can be offered as a private delivery and tailored for your team's specific needs