We have a database table that's a queue for jobs to process. I've added a SQL sensor to query the length of that queue, which returns me back an integer that I monitor and graph. Sometimes, the application that processes that queue crashes and we have to restart it. I'd like to build a notification that goes something like this....Notify me when the queue length has stayed the same for the past 10 minutes and the queue length is greater than 0. Is this possible?
Article Comments
Attention: This article is a record of a conversation with the Paessler support team. The information in this conversation is not updated to preserve the historical record. As a result, some of the information or recommendations in this conversation might be out of date.
Hello there,
I'm afraid that won't work, since no notification trigger can be based on comparing last readings to the current one. The threshold trigger can do this to some extent, but only in terms of when the threshold is reached (current reading is greater than/smaller than/equal to some defined value) and then starts counting the time for how log it persists before the notification is being sent (or not).
Kind regards,
Erhard
May, 2017 - Permalink