:tuid
, а в другом - :uid
. Это нормальное поведение, или опечатка? Trigger function nodata() is extremely useful for monitoring of hearbeats. You make create a script which would periodically send a value to ZABBIX server (crontab + zabbix_sender), and the nodata() trigger would detect if there is no data coming from the script within a period of time.
>>Is there a way to change max memory in the Registry?
Changing memory settings using sp_configure does not require to reboot windows so I am assuming it is not stored in windows registry.
So answer is you **cannot**. That particular settings itself is probably stored in one of the system tables inside SQL server.
In this case a plain restart was not enough - SQL Server died because out of memory directly. I had to use -f to save the show.
Simple checks are normally used for remote agent-less checks of services.
Note that Zabbix agent is not needed for simple checks. Zabbix server/proxy is responsible for the processing of simple checks (making external connections, etc).