How would I create an alert in DPA for when this (edited) query is greater 30 seconds?
USE <database>
GO
select count(*)
from <table>
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-Alert.htm
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.
