Detailed explanation of the process of zabbix monitoring sqlserver

Let's take a look at zabbix monitoring sqlserver. First download and install freetds

wget -c http://ibiblio.org/pub/Linux/ALPHA/freetds/stable/freetds-stable.tgz
tar -zxvf freetds-stable.tgz
cd freetds-0.91/
./configure --prefix=/usr/local/freetds --with-tdsver=8.0 --enable-msdblib
make && makeinstall

FreeTDS is installed in the /usr/local/freetds directory by default, and the library files are in the corresponding lib directory.

#vim /etc/ld.so.conf
/usr/local/freetds/lib

Configuration takes effect

#ldconfig

Modify /usr/local/freetds/etc/freetds.conf global configuration version number tds version to 8.0

#vim /usr/local/freetds/etc/freetds.conf
[global]
        # TDS protocol version
; tds version = 4.2
	tds version = 8.0

Connection Test

/usr/local/freetds/bin/tsql -H 192.168.31.158 -p 1433 -U sa -P 12345678

Install unixODBC unixODBC-devel

yum -y install unixODBC unixODBC-devel

Modify the configuration

#vim /etc/odbcinst.ini
[FreeTDS]
Driver = /usr/local/freetds/lib/libtdsodbc.so.0

#vim /etc/odbc.ini 
[sql1]
Driver = FreeTDS
Server = 192.168.31.158
PORT = 1433
TDS_Version = 8.0
 
[sql2]
Driver = FreeTDS
Server = 192.168.31.159
PORT = 1433
TDS_Version = 8.0

Test the connection

#isql -v sql1 sa 12345678
+---------------------------------------+
| Connected! |
| |
| sql-statement |
| help [tablename] |
| quit |
| |
+---------------------------------------+
SQL>

Select a template

This is the end of this article about zabbix monitoring sqlserver. For more relevant zabbix monitoring sqlserver content, please search 123WORDPRESS.COM's previous articles or continue to browse the following related articles. I hope everyone will support 123WORDPRESS.COM in the future!

You may also be interested in:

Detailed explanation of how to use zabbix to monitor oracle database
The implementation principle of Zabbix dynamic execution monitoring collection script
Using zabbix to monitor the ogg process (Linux platform)

<<: Six important selectors in CSS (remember them in three seconds)

>>: Summary of the differences between global objects in nodejs and browsers