Feature Request: Alert when table record count > x

[jacobgexigo]

We have certain tables that are queue tables that clear out as a service processes the records. We have written a checker that looks at any table that we specify (in this case LIKE '%Queue') and if record count gets to X then we get an email so we can triage it as it typically means the service has stopped processing the queue for some reason.

It would be nice to be able to have an alert for a scenario like this with an inclusive or exclusive filter capability. Inclusive for this specific example is best because there may only be 10 tables out of 1,000 that we want to alert on and exclusive would be cumbersome. On the other hand, if you want to know if any table gets to X records, then of course exclusive would be the better filter for that.

[DavidWiseman]

You could create a custom performance counter that has a count of the number of items in the table. Once it's in a performance counter you will be able to alert on it.