HADR Virtual Chapter – Monitoring Always On Availability Groups

  • Article

This past week SQL Server Tiger Team delivered a webinar session for the HADR PASS virtual chapter. During the session, I talked about some of the enhancements which were introduced in SQL Server 2016 and SQL Server 2016 Service Pack 1. The enhancements which I covered during the session fall in three broad categories

  1. Fundamental Changes to Always On Availability Groups
  2. Performance and Usability enhancements
  3. Troubleshooting and Monitoring enhancements.

During the session, I talked about the Automatic Seeding capability with SQL Server 2016 Always On Availability Group and the new latency dashboard which we are adding to SQL Server Management Studio vNext. The latency dashboard is currently in development and is expected to be available sometime in the next semester. The session recording, the slide deck and the scripts used during the demo are included below.

Session Recording

https://www.youtube.com/watch?v=qyjR9Yv9qeY\&feature=youtu.be

Presentation

Demo Scripts

The Demo Scripts for the session can be downloaded here.

 

Sourabh Agarwal
Senior PM, SQL Server Tiger Team
Twitter | LinkedIn
Follow us on Twitter: @mssqltiger | Team Blog: Aka.ms/sqlserverteam