Availability Group Best Practice Checks

[JamesFerebee]

Add Best Practices report section to:

1. Check if hadr endpoint is enabled/running. If not, flag it.
2. Report if any databases in an AG are showing unhealthy. If so, flag it. (see AG dashboard for reference)

[PiJoCoder]

Possibly query to use:

SELECT dc.database_name, d.synchronization_health_desc, d.synchronization_state_desc, d.database_state_desc 
FROM sys.dm_hadr_database_replica_states d 
JOIN sys.availability_databases_cluster dc 
  ON d.group_database_id = dc.group_database_id AND d.is_local = 1

[PiJoCoder]

SELECT group_name, 
  operational_state_desc, 
  connected_state_desc, 
  synchronization_health_desc
FROM tbl_hadr_ag_replica_states
WHERE operational_state_desc <> 'ONLINE'

SELECT 
  name as AG_Name, 
  synchronization_health_desc 
FROM tbl_hadr_ag_states
WHERE synchronization_health_desc  <> 'HEALTHY'

SELECT 
  name as HADR_Endpoint, 
  type_desc, 
  state_desc 
FROM tbl_hadr_endpoints_principals
WHERE state_desc <> 'STARTED'