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
49 stars 27 forks source link

Issue with alert #44

Open farzadha2 opened 1 year ago

farzadha2 commented 1 year ago

Hi @MantasTumenas Currently i have zabbix 6.2 and the template is working and showing the info, but it seems that its not triggering image the data shows but some odd reason its not triggering in this case should of triggered the diff backup and log backup

Thank you

MantasTumenas commented 1 year ago

What is the status of the said triggers? Enabled/Disabled?

farzadha2 commented 1 year ago

Hi @MantasTumenas Thank you so much for the reply, currently on the discovery im seeing this image

image

farzadha2 commented 1 year ago

hI @MantasTumenas I think i might of found the error

Cannot evaluate expression: right operand "30H" is not a numeric value for operator at ">{$MSSQL.BACKUP_FULL.CRIT:"MYDATABASE"}"

MantasTumenas commented 1 year ago

Where does the right operand "30H" comes from? For backup it should be "30" without "H", if I correctly understand your intentions.

MantasTumenas commented 1 year ago

farzadha2 Did it help?

farzadha2 commented 1 year ago

HI @MantasTumenas sorry for the late reply, it seemed that the comment i put few days ago did not save it as from image

MantasTumenas commented 1 year ago

For backup it should be "30" without "H"

farzadha2 commented 1 year ago

Hi @MantasTumenas Thank you so much for the reply, as for the "H" how would i remove that option or howcome its showing that "H" was it from the template or is it from the powershell itself?

MantasTumenas commented 1 year ago

I'm checking the images you have attached. Are you sure this trigger from my template? Cannot find this key MSSQL.BACKUP_FULL.CRIT

farzadha2 commented 1 year ago

Hi @MantasTumenas Thank you so much for the reply, sorry you were right i was looking at another template i had this is the correct one image

let me know if you need more pictures

Thank you again

MantasTumenas commented 1 year ago

Invalid second parameter means invalid value for macro UDBLTIME2. What values for this macro are? It should be on the host parameters

farzadha2 commented 1 year ago

Hi @MantasTumenas Thank you so much for the reply, currently i have this on the macros

image

MantasTumenas commented 1 year ago

Cannot trouble shoot like this. Can we do a shot online session? What is your timezone?

farzadha2 commented 1 year ago

Hi @MantasTumenas Thank you so much for the reply, currently my time is COT let me know what time and day thank you again

MantasTumenas commented 1 year ago

Send me your contact details to mantas.tumenas[at]gmail.com

MantasTumenas commented 1 year ago

Issue details received. Probable cause - Zabbix version 6.0. Currently checking on my own servers

killmasta93 commented 8 months ago

hi @MantasTumenas was this able to be solved?