Zabbix增加自定义Sqlserver监控

参考
https://blog.csdn.net/akquec08880/article/details/101566032

###odbc方式监控sqlserver状态###

1、sqlserver创建监控用户

创建登录名zabbix 权限：public

对zabbix增加服务器权限：查看服务器状态/view server state

2、安装依赖包
yum install unixODBC unixODBC-devel 

rpm -ivh freetds*      #freetds需要下载，系统盘中没有

3、配置odbc
vi /etc/odbcinst.ini

[FreeTDS]
Driver = /usr/lib64/libtdsodbc.so.0

vi  /etc/odbc.ini 

[123.123.123.123]
Driver = FreeTDS
Server = 123.123.123.123  #服务器IP
PORT = 1433  #SQL端口
TDS_Version = 8.0  #TDS版本

4、测试odbc配置

isql -v 123.123.123.123 zabbix password

+---------------------------------------+

| Connected!                            |

|                                       |

| sql-statement                         |

| help [tablename]                      |

| quit                                  |

|                                       |

+---------------------------------------+

SQL> quit

5、在zabbix中创建新的监控模板，增加监控项

对应主机添加模板时需要给$HOST赋值，为/etc/odbc.ini中配置的连接串名称