I'm trying to track a process that locks up regularly. It's a funky program that we have no control over. I'm trying to find a good way to track when the program stops responding.
I have a query which has a result... It comes back with 2 numbers: an integer and a time. The integer is "Items in Queue" and the time is "Time last item was processed".
What I'm trying to find out... is what is the best way to get these result into the Zabbix Database? How can I query SQLServer\DatabaseX either once to populate two items... or twice to seperately fill these two Items? Can I use Zabbix to run a Stored Procedure (which can be set to return whatever) and return that info via Agent?
IF I can get the result of a stored procedure... can I update two Items with one result or would i have to have two queries?
The zabbix_sender program is going to be your most portable way to push the item into the Zabbix db. You will need to write a script which takes the resultant data, splits it into two then sends the two items back using the zabbix_sender as it can handle mutliple values, if properly formatted.
Zabbix Sender man page
For extra DB metrics collection check DBforBIX:
http://www.smartmarmot.com/2011/05/dbforbix-0-2dbforbix-now-run-on-windows-as-a-service/
It supplies a Query List File to auto run your customized queries.