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

**URL:** <https://community.dynatrace.com/t/seeking-guidance-optimizing-response-time-degradation-anomaly-detection-thresholds-for-sql-server-databases/49506>\
**Category:** Alerting\
**Tags:** databases, problem-detection\
**Created:** [December 27, 2024, 4:49pm UTC](https://community.dynatrace.com/t/seeking-guidance-optimizing-response-time-degradation-anomaly-detection-thresholds-for-sql-server-databases/49506 "2024-12-27T16:49:23Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![lwaldrop](https://avatars.discourse-cdn.com/v4/letter/l/8e8cbc/32.png) [@lwaldrop](https://community.dynatrace.com/u/lwaldrop)\
**Post date:** [December 27, 2024, 4:49pm UTC](https://community.dynatrace.com/t/seeking-guidance-optimizing-response-time-degradation-anomaly-detection-thresholds-for-sql-server-databases/49506/1 "2024-12-27T16:49:23Z")

</div>

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
