We are using DPA 2021.1 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 .