Zabbix Monitoring Database MSSQLServer

Zabbix connects SQL Server via ODBC and obtains data from the database via ODBC;

The configuration is as follows:

Execute the following command on the Zabbix-server side:

# yum-y Install FreeTDS UnixODBC unixodbc-devel

$ vi/etc/odbcinst.ini[freetds]driver =/usr/lib64/libtdsodbc.so.0

PORT = 1433tds_version = 8.0[sql2]driver = Freetdsserver = <sql server 2 Ip>port = 1433tds_version = 8.0

Zabbix-server-Side verification:

# isql–v SQL1 Database account  Database password

Zabbix configuration:

Host macro configuration, add parameters, of course {$PASSWORD} {$USER} can be removed, the following we configured the project when the specific;

So we can get the results from the database in the SQL query we configured.

Because the display is in XML format, it is optimized again.

To be Continued ...

Zabbix Monitoring Database MSSQLServer