Hi,
I’m using sqlserver plugin in telegraf to monitor ms SQL server.
In failover metric outputs,as of now I can get 1 and 2 values for failover_mode field.
May I know what is meaning for this field values.
Regards
Bala.
here is the statement
SELECT
''sqlserver_hadr_replica_states'' AS [measurement]
,REPLACE(@@SERVERNAME, ''\'', '':'') AS [sql_instance]
,convert(nvarchar(36), hars.replica_id) as replica_id
,ar.replica_server_name
,convert(nvarchar(36), hars.group_id) as group_id
,ag.name AS group_name
,hags.synchronization_health_desc AS ag_synchronization_health_desc
,ar.replica_metadata_id
,ar.availability_mode
,ar.availability_mode_desc
,ar.failover_mode
,ar.failover_mode_desc
,ar.session_timeout
,ar.primary_role_allow_connections
,ar.primary_role_allow_connections_desc
,ar.secondary_role_allow_connections
,ar.secondary_role_allow_connections_desc
,hars.is_local
,hars.role
,hars.role_desc
,hars.operational_state
,hars.operational_state_desc
,hars.connected_state
,hars.connected_state_desc
,hars.recovery_health
,hars.recovery_health_desc
,hars.synchronization_health AS replica_synchronization_health
,hars.synchronization_health_desc AS replica_synchronization_health_desc
,hars.last_connect_error_number
,hars.last_connect_error_description
,hars.last_connect_error_timestamp'
+ @Columns + N'
FROM sys.dm_hadr_availability_replica_states AS hars
INNER JOIN sys.availability_replicas AS ar on hars.replica_id = ar.replica_id
INNER JOIN sys.availability_groups AS ag on ar.group_id = ag.group_id
INNER JOIN sys.dm_hadr_availability_group_states AS hags ON hags.group_id = ag.group_id
