cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Seeking Guidance: Optimizing 'Response Time Degradation' Anomaly Detection Thresholds for SQL Server Databases

lwaldrop
Participant

We are receiving multiple alerts for SQL stored procedures exceeding adjusted relative thresholds. Typically, the slowest 10% do not surpass 500 ms. Could you advise on determining optimal relative thresholds or whether fixed thresholds might be more effective? These stored procedures are linked to batch processes with varying execution frequencies throughout the month. Below are examples of alerts received yesterday.

349 requests/min impacted
The current response time (373 ms) exceeds the auto-detected baseline (44 ms) by 747 %
Service method: 8 Service methods

451 requests/min impacted
The current response time (51.4 ms) exceeds the auto-detected baseline (6.24 ms) by 723 %
Service method: 5 Service methods

0 REPLIES 0

Featured Posts