Zabbix 监控 RDS SQL Server数据库–2 创建模板监控项

在Zabbix Server 创建监控的模板







模版创建好后，创建监控项：
check.rds_sqlserver[Performance,{$DBINSTANCEID},SQLServer_InstanceCPUUsage,{$ACCESSKEY_ID},{$ACCESSKEY_SECRET}]



check.rds_sqlserver[Performance,{$DBINSTANCEID},SQLServer_IOPS,{$ACCESSKEY_ID},{$ACCESSKEY_SECRET}]
 check.rds_sqlserver[Performance,{$DBINSTANCEID},SQLServer_Sessions,{$ACCESSKEY_ID},{$ACCESSKEY_SECRET}]  check.rds_sqlserver[Performance,{$DBINSTANCEID},SQLServer_NetworkTraffic_IN,{$ACCESSKEY_ID},{$ACCESSKEY_SECRET}]  check.rds_sqlserver[Performance,{$DBINSTANCEID},SQLServer_NetworkTraffic_OUT,{$ACCESSKEY_ID},{$ACCESSKEY_SECRET}] 

check.rds_sqlserver[Performance,{$DBINSTANCEID},SQLServer_Transactions,{$ACCESSKEY_ID},{$ACCESSKEY_SECRET}]  check.rds_sqlserver[Performance,{$DBINSTANCEID},SQLServer_QPS,{$ACCESSKEY_ID},{$ACCESSKEY_SECRET}]



check.rds_sqlserver[Performance,{$DBINSTANCEID},SQLServer_BufferHit,{$ACCESSKEY_ID},{$ACCESSKEY_SECRET}]
 check.rds_sqlserver[Performance,{$DBINSTANCEID},SQLServer_CheckPoint,{$ACCESSKEY_ID},{$ACCESSKEY_SECRET}]  check.rds_sqlserver[Performance,{$DBINSTANCEID},SQLServer_Logins,{$ACCESSKEY_ID},{$ACCESSKEY_SECRET}] 

check.rds_sqlserver[Performance,{$DBINSTANCEID},SQLServer_FullScans,{$ACCESSKEY_ID},{$ACCESSKEY_SECRET}]
 check.rds_sqlserver[Performance,{$DBINSTANCEID},SQLServer_SQLCompilations,{$ACCESSKEY_ID},{$ACCESSKEY_SECRET}]  check.rds_sqlserver[Performance,{$DBINSTANCEID},SQLServer_LockTimeout,{$ACCESSKEY_ID},{$ACCESSKEY_SECRET}]  check.rds_sqlserver[Performance,{$DBINSTANCEID},SQLServer_Deadlock,{$ACCESSKEY_ID},{$ACCESSKEY_SECRET}]  check.rds_sqlserver[Performance,{$DBINSTANCEID},SQLServer_LockWaits,{$ACCESSKEY_ID},{$ACCESSKEY_SECRET}] 

check.rds_sqlserver[Disk,{$DBINSTANCEID},LogSize,{$ACCESSKEY_ID},{$ACCESSKEY_SECRET}]



check.rds_sqlserver[Disk,{$DBINSTANCEID},BackupSize,{$ACCESSKEY_ID},{$ACCESSKEY_SECRET}]



check.rds_sqlserver[Disk,{$DBINSTANCEID},DiskUsed,{$ACCESSKEY_ID},{$ACCESSKEY_SECRET}]
 check.rds_sqlserver[Disk,{$DBINSTANCEID},DataSize,{$ACCESSKEY_ID},{$ACCESSKEY_SECRET}]  check.rds_sqlserver[Attribute,{$DBINSTANCEID},MaxIOPS,{$ACCESSKEY_ID},{$ACCESSKEY_SECRET}]

 check.rds_sqlserver[Attribute,{$DBINSTANCEID},MaxConnections,{$ACCESSKEY_ID},{$ACCESSKEY_SECRET}]



check.rds_sqlserver[Attribute,{$DBINSTANCEID},DBInstanceStatus,{$ACCESSKEY_ID},{$ACCESSKEY_SECRET}]  check.rds_sqlserver[Attribute,{$DBINSTANCEID},DBInstanceStorage,{$ACCESSKEY_ID},{$ACCESSKEY_SECRET}]



check.rds_sqlserver[Attribute,{$DBINSTANCEID},DBInstanceStorageType,{$ACCESSKEY_ID},{$ACCESSKEY_SECRET}]

 check.rds_sqlserver[Attribute,{$DBINSTANCEID},DBInstanceCPU,{$ACCESSKEY_ID},{$ACCESSKEY_SECRET}] 

check.rds_sqlserver[Attribute,{$DBINSTANCEID},DBInstanceMemory,{$ACCESSKEY_ID},{$ACCESSKEY_SECRET}]



硬盘使用率=(SQLServer已使用磁盘空间/1024/1024) / RDS MySQL Disk*100
last("check.rds_sqlserver[Disk,{$DBINSTANCEID},DiskUsed,{$ACCESSKEY_ID},{$ACCESSKEY_SECRET}]")/last("check.rds_sqlserver[Attribute,{$DBINSTANCEID},DBInstanceStorage,{$ACCESSKEY_ID},{$ACCESSKEY_SECRET}]")/1024/1024/1024*100



IOPS使用率=每秒IO请求次数/最大IOPS数 *100

custom.iops.pused
100*last("check.rds_sqlserver[Performance,{$DBINSTANCEID},SQLServer_IOPS,{$ACCESSKEY_ID},{$ACCESSKEY_SECRET}]")/last("check.rds_sqlserver[Attribute,{$DBINSTANCEID},MaxIOPS,{$ACCESSKEY_ID},{$ACCESSKEY_SECRET}]")



连接数使用率= 当前总连接数/    RDS MySQL MAX Connections*100

custom.sessions.pused
100*last("check.rds_sqlserver[Performance,{$DBINSTANCEID},SQLServer_Sessions,{$ACCESSKEY_ID},{$ACCESSKEY_SECRET}]")/last("check.rds_sqlserver[Attribute,{$DBINSTANCEID},MaxConnections,{$ACCESSKEY_ID},{$ACCESSKEY_SECRET}]")