search

MantasTumenas / Zabbix-template-for-Microsoft-SQL-Server

Zabbix templates for Microsoft SQL Server. Features MS SQL performance counters. MS SQL instance Low Level Discovery. MS SQL database Low Level Discovery. MS SQL agent job Low Level Discovery. MS SQL database mirroring monitoring. MS SQL Always On monitoring. MS SQL Log Shipping monitoring. Supported versions Tested on Microsoft SQL Server 2012, 2014 and 2016. It may work with earlier versions, but some items (with missing performance counters) may be unsupported. For the extensive overview on the performance counters difference between MS SQL 2008 and MS SQL 2012 you can read here (https://blog.dbi-services.com/sql-server-2012-new-perfmon-counters/). Tested on Zabbix 3.4.0. It may work with earlier versions, but some items (for example service.info[service,]) may be unsupported. The template was started on Zabbix 2.4.0 but after each new Zabbix version, objects were modified or new things were added.
GNU General Public License v3.0
50 stars 27 forks source link

Import Templates Have't Items #13

Closed UneasyTheWay closed 5 years ago

UneasyTheWay commented 5 years ago

After import Template Template Microsoft SQL Server DE Baseline.xml (With SQL instance discovery\Templates), Zabbix have't items

MantasTumenas commented 5 years ago

If imported template is seen in host Discovery section and they are shown as Enabled, then you need to wait a little. For some 1 min, for some 15 min. Depends on the server. How your situation is today?

UneasyTheWay commented 5 years ago

If imported template is seen in host Discovery section and they are shown as Enabled, then you need to wait a little. For some 1 min, for some 15 min. Depends on the server. How your situation is today?

Do you need to configure the account password of the database?

MantasTumenas commented 5 years ago

No, you do not. But as stated in a documentation - Grant rights for Zabbix Agent service account. By default, Zabbix Agent service account is NT AUTHORITY\SYSTEM which is already in SQL Server

ioannis-pan commented 5 years ago

I have the same issue, it worked only once on another machine. Please help me, it is a critical matter for me.

MantasTumenas commented 5 years ago

Ok, I need zabbix agent log, zabbix conf file, user parameters file and printscreen, from host discovery tabs and host items tabs

MantasTumenas commented 5 years ago

ioannis-pan issue moved to a separate issue. Original issue closed due to no response from UneasyTheWay