SELECT COUNT (*), as NotHealtyCount 得到sys.dm_hadr_cluster_members WHERE member_state_desc  !=& # 39;了# 39;;引用>
SELECT COUNT (*), as DBCount 得到sys.availability_databases_cluster;引用>
SELECT COUNT (*), as NotHealtyCount 得到(主)。[sys]。[dm_hadr_database_replica_states] WHERE [synchronization_health_desc], !=, n # 39;健康# 39;引用>
;WITH AG_Stats AS ( SELECT AR.replica_server_name, ,,HARS.role_desc,, ,,Db_name (DRS.database_id), [DBName), DRS.last_commit_time。才能 得到,,sys.dm_hadr_database_replica_states DRS INNER JOIN  sys.availability_replicas AR 提醒DRS.replica_id =, AR.replica_id INNER JOIN  sys.dm_hadr_availability_replica_states HARS 提醒AR.group_id =, HARS.group_id 以及AR.replica_id =, HARS.replica_id ), Pri_CommitTime AS ( SELECTreplica_server_name ,DBName ,last_commit_time FROMAG_Stats 时间=WHERErole_desc & # 39;主要# 39; ), Sec_CommitTime AS ( SELECTreplica_server_name ,DBName ,last_commit_time FROMAG_Stats 时间=WHERErole_desc & # 39;二次# 39; ) SELECT ISNULL (DATEDIFF(党卫军,s.last_commit_time p.last_commit_time), 0), AS [Sync_Lag_Secs] 得到Pri_CommitTime p LEFT JOIN  Sec_CommitTime s 提醒[s]。[DBName],=[p]。[DBName]引用>
引用>
建议,将1、3、4项配置为模板,2项需要单独配置4个参数。
Zabbix监控AlwaysOn