I have created a SQL Server User Experience Monitor, with a custom query, that returns an integer.
The result is fine, and I can use it for statistics and alerts.
However, the component stays in a critical state, because of the response time beeing too high.
Is there any way of customizint the thresholds for the SOAP Monitor MIN/MAX Average Response Time ?
In this case, It doesn't matter if the query takes 2 ms or 50 ms.
I misread the configuration, and there is an option for response time thresholds.