Search 6,000+ CA Community College Courses

Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

YouTube

SQL Server 2016 Always On Availability Groups Enhancements

PASS Data Community Summit via YouTube

Start learning Write review

Overview

Explore SQL Server 2016 Always On Availability Groups enhancements in this comprehensive one-hour presentation from PASS Data Community Summit. Dive into topics such as HA/DR backup and restore, failover cluster topology, and prototypical architecture with local non-shared storage. Learn about new features including fewer dependencies, Standard Edition support, Azure integration, improved security, and DTC support. Discover performance optimizations like log transport compression, readable secondary load balancing, and direct seeding. Compare SQL Server 2016 with previous versions, focusing on Hekaton improvements, log transport performance, and CPU usage across multiple replicas. Gain valuable insights into best practices for hotfixes, updates, and SORT_IN_TEMPDB implementation to maximize the potential of SQL Server 2016 Always On Availability Groups.

Syllabus

Intro
Technical Assistance
HA/DR: Backup & Restore
Other AG Components & Concepts
Failover Cluster Topology
Availability Group Topology
Prototypical Architecture of AGs with Local Non-Shared Storage
Best Practice: Hotfixes & Updates
AGs Enhancements: Fewer Dependencies
SQL Server Standard Edition Support Now that DBM has been marked for deprecation, this is welcome now!
Azure Integration
AGs Enhancements: Security
AGs Enhancements: Failover
AGs Enhancements: DTC Support
AGs Enhancements: Direct Seeding
Log Transport Compression Defaults & Options
Readable Secondary Round-Robin Load Balancing
Readable Secondary Azure Support
Read-Only Secondaries: Licensing & Performance
Best Practice: SORT_IN_TEMPDB
AG Performance Enhancements
Always On AGS: SQL 2016 vs. SQL 2014 (Hekaton)
Unleashing the Power of SQL Server 2016
SQL 2014 vs. 2016: Log Transport Performance (Engine)
SQL Server 2016 Async vs. Sync: Network Bandwidth Support
SQL Server 2014 vs. 2016 CPU% on Primary vs. Transactions (Sync, 3 Replicas, 3 Trials)

Taught by

PASS Data Community Summit

Reviews

Start your review of SQL Server 2016 Always On Availability Groups Enhancements

Start learning

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Sign up for free
Someone learning on their laptop while sitting on the floor.