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.