Regarding mssql_odbc template macros

[ekholve]

I am trying to evaluate the stock mssql_odbc template to monitor Microsoft SQL Server instances.

Zabbix server version:
zabbix_server (Zabbix) 5.2.5

I am using Zabbix Agent 2 (but have also Zabbix Agent 1 on other server)

The template should be able to monitor database backups? According to this page it should have macros for that:
Browse Zabbix / Zabbix - ZABBIX GIT

{$MSSQL.BACKUP_DIFF.WARN} The maximum days without a differential backup - for the Warning trigger expression.
{$MSSQL.BACKUP_DURATION.WARN} The maximum job duration - for the Warning trigger expression.
{$MSSQL.BACKUP_FULL.CRIT} The maximum days without a full backup - for the High trigger expression.
{$MSSQL.BACKUP_FULL.WARN} The maximum days without a full backup - for the Warning trigger expression.
{$MSSQL.BACKUP_LOG.CRIT} The maximum days without a log backup - for the High trigger expression.
{$MSSQL.BACKUP_LOG.WARN} The maximum days without a log backup - for the Warning trigger expression.

When I am configuring the template or host, I am unable to see those anywhere. Also no data regarding backups is shown in the dashboard (lots of other data from this template is getting through so I know it is able to contact the instance).

I am new to Zabbix so it is highly likely that solution is something really simple.

I know that there are other templates to monitor SQL Server but would like to prefer the one that is included with the product.

Thanks for your help.

[ekholve]

Anyone?

[ekholve]

In case somebody else is hitting the head against this same wall.

Seems that the stock template does not show those macro values at all. Deleting the template and importing it again seems to resolve the matter. Still waiting those macros to trigger these events but that is a different matter...

[Daniel4711]

Hello,

Until now I have always monitored the SQL servers with the Windows performance counters.
But the template seems to be closer here.... I will try it out!
Do you still use Performance Counter in parallel or is the template enough for you?

[ekholve]

Hello,

Until now I have always monitored the SQL servers with the Windows performance counters.
But the template seems to be closer here.... I will try it out!
Do you still use Performance Counter in parallel or is the template enough for you?

A bit late reply but the template does collect the performance counter data as well and yes I am collecting some of those counters too. Not sure if that answers to your question?