insei / zabbix_mssql_template

template with discovery by ODBC

Zabbix template for Microsoft SQL Server monitoring via perfmon, services and ODBC.

This template monitors SQL Server databases status, jobs status, server performance.

Requirements:

• Zabbix 2.2
• unixODBC
• freeTDS

Installation:

• Before install template, create in Zabbix Value Mapping:

  Name of mapping: MS SQL Server database state

  Value	Mapped to
  0	ONLINE
  1	RESTORING
  2	RECOVERING
  3	RECOVERY PENDING
  4	SUSPECT
  5	EMERGENCY
  6	OFFLINE
  7	Database Does Not Exist on Server

• and Zabbix Regular expressions:

  Name of regexp: MSSQL Databases for discovery
  Expression: ^(master|model)$
  Expression type: Result is FALSE
  
  Name of regexp: MSSQL Jobs for discovery
  Expression: ^(test)$
  Expression type: Result is FALSE
  

• To use ODBC, install unixODBC and freeTDS.

  Sample config ODBC:

  /etc/odbcinst.ini
  [FreeTDS]
    Description = FreeTDS Driver v0.91
    Driver = /usr/lib/i386-linux-gnu/odbc/libtdsodbc.so
    Setup = /usr/lib/i386-linux-gnu/odbc/libtdsS.so
    UsageCount = 1 
  
  /etc/odbc.ini
  [1c_base]
    Driver = FreeTDS
    ServerName = 1c_base
  
  /etc/freetds/freetds.conf
  [1c_base]
    host = 10.1.0.1
    port = 1433
    client charset = UTF-8
    tds version = 8.0

• And configure SQL Server to access data for ODBC user [zab]:

  CREATE LOGIN [zab] WITH PASSWORD=N'****', DEFAULT_DATABASE=[master], DEFAULT_LANGUAGE=[us_english],     CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF
  
  GRANT VIEW SERVER STATE to [zab]
  GRANT VIEW ANY DEFINITION TO [zab]
  GRANT SELECT ON sys.sysaltfiles TO [zab] 

  And create user mapping to read data from master and msdb.