27 Dec 2024 04:49 PM
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