Always ON Master Series Class 2 Sql Server Always On Basics and Evaluation || Contact +91 9902590140
If anyone is looking for Sql DBA, Azure Sql DBA Training, PowerBi, Tableau, Oracle DBA, Linux, Azure and AWS DevOps Real Time Trainings and Online Job Support, Interview Support, Videos, Notes Please Whatsapp me @ 9902590140 or Send an Email to [email protected]
Thank You
Always On master sessions
Topics To be Covered
1. Introduction to Always On
2. Legacy Architecture: Database Mirroring for High Availability and Log Shipping for Disaster Recovery
3. AlwaysOn Availability Groups for High Availability and Disaster Recovery
4. Deployment Planning and Considerations
a. Topology Prerequisites
i. Unit of Failover
ii. Considerations for Replacing Log Shipping for DR
5. Quorum Model and Node Votes
6. Always On Demo and Configurations
a. Creating VMs
b. Setting up the Windows Cluster
7. Setting up Different Types of Always On
a. Traditional Always On
b. Multi Subnet Always On
c. Clusterless Always On
d. Distributed availability groups
e. SQL 2022 new feature contained availability groups
8. Patching Always On Replicas
9. Upgrading and Migrating Always On Instances
10. Adding and Removing the Database in AG setup
11. Adding files with the same path and different paths in the AG setup
12. AG Database Refresh Activity
13. Setting up TDE on AG Databases
14. Working with CDC on AG databases
15. Table Portioning on AG databases
16. Setting up Replication on AG databases
17. Common Issues on Always On
a. Login Failures on Secondary
b. Job Failures
c. Shrinking Log file of the AG databases
d. Synchronization issues
e. Performance issues with AG setup
f. Configuration failures
g. Failed to add database to the alwayson
h. Failed to create listener
18. Alwayson performance internals and troubleshooting
a. How alwayson synchronization works in synchronous and asynchronous replicas
b. Alwayson worker pool or worker threads
c. High log send queue latency
d. High redo latency
19. Configure alwayson in IaaS and setup listener in Azure IaaS (load balancer)
20. Interview Questions on AG
21. Best Practices with AG
22. Extended Events
23. Query store
24. DMVs for alwayson
Date : 2nd December 2023
Time : Saturdays and Sundays Morning 7 to 9 IST
Duration : 1 – 1 and half Months
Mode of Language : English
Recordings and Notes Also Provided
