In-Person Monitoring your SQL Server AlwaysOn Availability Groups w/ Eric & Amy
Details
Meeting IN-PERSON
Monday, July 10, 2023
Networking begins at 6:15PM
Speaker will begin 6:30-6:45, based on attendance.
Location:
Improving Atlanta Offices
11675 Rainwater Dr #100
Alpharetta, GA 30009
Monitoring your SQL Server Always On Availability Groups with Eric Peterson and Amy Cox
Abstract:
Always On availability groups is the go-to technique for SQL Server high availability (HA) for both on-premises and the cloud. But setting up your Always On availability group is only the first step. Proper configuration and constant monitoring of your HA environment is needed to make sure that the transactions are making it to the secondary environment in a timely manner and that you can fail over to meet your service level agreements.
This presentation will cover how to monitor your HA system, and how to resolve several issues that you will encounter with Always On availability groups. Several SQL and PowerShell code samples will be provided that can be used in your environment to assist in the process of keeping your system up.
Prerequisites:
The user should understand the concepts of Always On availability groups, listeners and fail over, but basic setup and configuration will be covered so
Goals:
- Outline what issues can occur after setting up your Always On availability groups
- Provide the processes for real time monitoring of your Always On availability groups
- Provide recommendations and solutions for keeping your system highly available
Eric Peterson – Bio
- Over 40 years of Database experience
- Over 25 years SQL Server experience from 4.1 to SQL 2022.
- Former lead architect for Sybase ( the company that wrote SQL Server)
- ODBC development and beta team member
- Wrote sp_who2
Amy Cox - Bio
- Independent consultant focusing on cloud migrations.
- 25 years of SQL Server experience starting with 6.5
- Once flew an F-15
- Recovering marathoner and Ironman