DeepDive High Availability - AlwaysOn Availability Groups

DM-HADDAG-EN

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

WHEN and WHERE is this course running?

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

Contact us

WHEN and WHERE is this course running next?

Check dates