Hi
I have a trigger which monitors number of items in a table. If an average number of items in this table is higher than a threshold (within a given period of time) an alert is generated. Here is a trigger expression used by me:
{SERVER:SQLQuery["DB_NAME","SELECT COUNT(*) FROM dbo.TableName"].avg(60)}> 5
My question is: Does it mean that every X seconds Zabbix send a request to a database?
Or maybe it is clever enough to use a mechanism like Track Data Changes from MSSQL.
I have a trigger which monitors number of items in a table. If an average number of items in this table is higher than a threshold (within a given period of time) an alert is generated. Here is a trigger expression used by me:
{SERVER:SQLQuery["DB_NAME","SELECT COUNT(*) FROM dbo.TableName"].avg(60)}> 5
My question is: Does it mean that every X seconds Zabbix send a request to a database?
Or maybe it is clever enough to use a mechanism like Track Data Changes from MSSQL.