I have DPA and I thought this alert would be easy to create but cannot seem to figure out how to create an alert that, whenever a table is updated, it sends an alert.
We have a database table that ONLY gets written to when a specific error happens.
Anyone have any thoughts?
Hi, not sure it can be done in DPA. My tool of choice would be SAM. There you can create any SQL query against the db you are monitoring.
Create a query that shows how many new rows you got in the last timeframe you want. Or use the link @mesverrum gave to look at the table itself
Remember that you have to return 0 even if you don't get any hits. NULL is not allowed.
Probably need to do it as a custom metric or custom alert, this query could be a starting point
datediff that value and alert any time it is below 10 or so?
SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community. More than 150,000 members are here to solve problems, share technology and best practices, and directly contribute to our product development process.