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

custom alert on wait time per execution for single sql or total sql

hi there:

 We are using DPA 2020.2 version to monitor MSSQL instance and I'd like to know if there is a way to set up alert on SP based on wait time per execution. Some SP , in normal time, wait time per execution is less than 10 millionSec.  If wait time per execution is above 100 millionsec, I want to receive an alert. 

 I've checked DB instance wait time anomaly but it is targeting the wait time on the whole instance which is not that useful in our case. 

Thanks in advance . 


Cheers

 

 Hui

0 Kudos
1 Reply
Level 17

@hshi DPA focuses on statements, not stored procedures. However, this post may be helpful: https://thwack.solarwinds.com/t5/DPA-Documents/DPA-Report-on-Stored-Proc-Impacts/ta-p/528447

0 Kudos