cancel
Showing results for 
Search instead for 
Did you mean: 
Create Post
Level 12

Alert on query execute time

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-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. 

0 Kudos
1 Reply
Level 12

From what I have found so far is SAM is the best solution for what I need to do. 

0 Kudos