SQL Status Monitoring Agent
Why do we need SQL status monitoring?
Sometimes applications that we do not control keep their status information in SQL data bases. We
need to know when given values change, as they change, so we can perform actions based on this
The SQL status monitor is an agent of the Genie - Monitoring platform product that queries data from
databases on a large scale to discover changes in table fields. It launches a user defined event
handler when such a change occurs.
The agent is created to perform this operation very fast using asynchronous operations and complex
algorithms that enables it to monitor multiple databases and multiple fields in short cycles. The
agent does not wait for a response from a given node to monitor other nodes.
It contains many flow control parameters that enable it to work in all kinds of networks.
On the node level, the agent supports:
- Monitoring frequency
- Monitoring hours
- Number of threads used