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 .
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. Learn more today by joining now.