This discussion has been locked. The information referenced herein may be inaccurate due to age, software updates, or external references.
You can no longer post new replies to this discussion. If you have a similar question you can start a new discussion in this forum.

FEATURE REQUEST - Send alert when the wait time is above a particular threshold Case # - 00450909

MS-SQL Server monitoring: I want to monitor a specific SQL Hash and send an alert when the wait time is above a particular threshold.

By using average, spikes do not trigger the alerts because the average results in a false negative state to trigger the alert. That is why we need to trigger the alert by current value based on a threshold.  Whenever the current value is above the threshold the alert is triggered.