Zabbix monitoring Add Psql database and Sql_server database templates

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