Operations | Monitoring | ITSM | DevOps | Cloud

August 2020

Monitoring Always On Availability Groups and Always On Failover Cluster in Spotlight

SQL Server provides us with a number of high availability and disaster recovery solutions. Two of them are Always On Availability Groups and Always On Failover Cluster offerings. In order to leverage these options, they themselves need to be constantly evaluated. Therefore, monitoring the health and status of these Always On instances is critical, but how do we optimally configure them in Spotlight? My aim is to provide insight to the configuration steps based on the type of Always On instance.

SQL Optimization

Using Foglight and SQL Optimizer you can identify poorly performing queries and rewrite them or generate a more efficient execution plan. First, use Performance Investigator to identify and select the query you wish to tune, i.e., by number of executions, IO, CPU time, etc. The video explains how to use SQL Optimizer for better query performance.