First, Psql Database performance monitoring:
1 ) zabbix-agent Client Installation Pg_monz steps:
[Email protected] ~]# TARXFZ pg_monz-1.0.1.tar.gz
[Email protected] ~]# Cdpg_monz-1.0.1/pg_monz
[Email protected]_monz]# cp find_dbname.sh find_dbname_table.sh/usr/local/bin/
[Email protected]_monz]# CP userparameter_pgsql.conf/etc/zabbix/zabbix_agentd.d/
[Email protected]_monz]# chmod +x/usr/local/bin/find_dbname.sh
[Email protected]_monz]# chmod +x/usr/local/bin/find_dbname_table.sh
[Email protected]_monz]#/etc/init.d/zabbix-agent Restart
2 ) Zabbix the service side only needs to Tar the monitoring templates provided in the package are imported to the Zabbix server.
Reference article: https://yq.aliyun.com/articles/9026
Http://blog.chinaunix.net/uid-20726500-id-4513716.html
Https://github.com/pg-monz/pg_monz/releases
Second, Spl_server Database Performance Monitoring
At present , Zabbix 's monitoring of the sql_server Database is a monitoring template for each institution, in each institution's sql_ the "zabbix_template_sqlserver_multidatabase_generator.sql" statement is executed onthe server database, and the resulting results are saved as XML file as a template and import it to the Zabbix server.
This article is from a "a little" blog, make sure to keep this source http://pengai.blog.51cto.com/6326789/1890368
Zabbix monitoring Add Psql database and Sql_server database templates