UIM - sqlserver probe - No alarms for aag_db_replica_synchronization_state

Products

• DX Unified Infrastructure Management (Nimsoft / UIM)

Issue/Introduction

sqlserver probe is not alerting on aag_db_replica_synchronization_state.  We have an alert that should be firing and is not.  When I check the status tab, it shows execution time 0.0000 sec.

Environment

Release : 9.x or later

Component : UIM - SQLSERVER

Resolution

Probably into the sql_server.cfg the parameter "is_AlwaysOn" is blank, so just set it to "1"

-> Open sqlserver_monitor.cfg and search for "is_AlwaysOn"

-> Update this filed(like "is_AlwaysOn = 1") with value 1 in all the places.

-> Restart the probe and check if there are any alerts for "NOT SYNCHRONIZING" states

Query to see the Sync Status:
select a.name, rtrim(b.replica_server_name) object, rtrim(d.name) database_name, c.synchronization_state, c.synchronization_state_desc from sys.availability_groups a,sys.dm_hadr_availability_replica_cluster_states b,sys.dm_hadr_database_replica_states c,master.sys.databases d where a.group_id = b.group_id and b.group_id = c.group_id and b.replica_id = c.replica_id and c.database_id = d.database_id