Zabbix: Database Monitor Installation

最新推荐文章于 2025-08-05 17:20:40 发布

weixin_30764771

最新推荐文章于 2025-08-05 17:20:40 发布

阅读量122

点赞数

CC 4.0 BY-SA版权

文章标签：运维数据库

原文链接：http://www.cnblogs.com/dfg727/p/5833780.html

本文档详细介绍了如何在Zabbix服务器上安装ODBC MSSQL连接器，并配置Zabbix来监控MSSQL数据库的过程。内容包括必要的软件安装、ODBC驱动配置、创建监控项、触发器及动作等步骤。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

1. Install ODBC MS SQL Connector On Zabbix Server

https://support.zabbix.com/browse/ZBX-6839 comment1 --> mysql comment2 --> PostgreSQL comment3 --> MSSQL

Install necessary packages FreeTDS:

yum -y install freetds unixODBC unixODBC-devel

Check if the installation is successful or not:

tsql -S 10.1.9.59 –P 1433 -U loginname –P password

1> select top 1 id from jobsdb_hk.dbo.jobad;

2> go

Update ODBC driver configuration file:

$ vi /etc/odbcinst.ini

Update ODBC configuration file:

$ vi /etc/odbc.ini

2. Create Host

3. Create Item

User name: [Adloader Database Login ID]

Password: [Adloader Database Login Password]

SQL Query:

Select (Select L.CreatedTime, ErrorLogXml 
    From [Dev_DM_DB01]..SCM_Gateway_Log L With(NoLock) 
    Where Convert(Nvarchar(max), ErrorLogXml) <> '' 
    And DATEDIFF(D, CreatedTime, GETUTCDATE()) = 0 
    For XML RAW,TYPE) As ErrorLogFromAdloader, 
    (Select B.BatchID, B.CreateDate, BRJ.PostToJobsDB_ErrorInfo, BRJ.JobTitle
        From [Dev_DM_DB01]..SCM_ImportJob_Batch B With(NoLock) 
        Inner Join [Dev_DM_DB01]..SCM_ImportJob_BatchRecord_JobsDB BRJ With(NoLock) 
    On B.AccountID=BRJ.AccountID And B.EntityID=BRJ.EntityID And     B.BatchID=BRJ.BatchID 
        Where BRJ.PostToJobsDB_ErrorInfo Is Not Null 
        And DATEDIFF(MI, B.LastProcessTime, GETUTCDATE()) < 60
        For XML RAW, Type) As ErrorLogFromJobsDB
For XML RAW