How would I create an alert in DPA for when this (edited) query is greater 30 seconds?
where transaction_datetime between CURRENT_TIMESTAMP - 1 and CURRENT_TIMESTAMP
and created between CURRENT_TIMESTAMP -1 and CURRENT_TIMESTAMP
I saw this document, but it seems to fit what I need. https://documentation.solarwinds.com/en/Success_Center/dpa/Content/GettingStarted/DPA-GS-Enable-Aler...
I thought I would be able to put in a query, have it execute every 10 minutes, evaluate how long it took for the response, and then alert appropriately.
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.