Anomaly detection for databases (builtin:anomaly-detection.databases) Dynatrace automatically detects database-service related performance anomalies such as response time degradations and failure rate increases.
Use these settings to configure detection sensitivity, set alert thresholds, or disable alerting for certain services. Read more about Automated multi-dimensional baselining .
To avoid false-positive problem notifications, automated anomaly detection is only available for applications and services that have run for at least 20% of a week (7 days).
Schema ID Schema groups Scope builtin:anomaly-detection.databasesSERVICE_METHOD - Request
SERVICE - Service
HOST_GROUP - Host Group
environment
Retrieve schema via Settings API GET Managed https://{your-domain}/e/{your-environment-id}/api/v2/settings/schemas/builtin:anomaly-detection.databasesSaaS https://{your-environment-id}.live.dynatrace.com/api/v2/settings/schemas/builtin:anomaly-detection.databasesEnvironment ActiveGate https://{your-activegate-domain}/e/{your-environment-id}/api/v2/settings/schemas/builtin:anomaly-detection.databases
Authentication To execute this request, you need an access token with Read settings (settings.read) scope. To learn how to obtain and use it, see Tokens and authentication .
Parameters Property Type Description Required Response timeresponseTime responseTime - required Failure ratefailureRate failureRate - required Service load dropsloadDrops loadDrops Alert if the observed load is lower than the expected load by a specified margin for a specified amount of time.
Dynatrace learns your typical service load over an observation period of one week.
required Service load spikesloadSpikes loadSpikes Alert if the observed load exceeds the expected load by a specified margin for a specified amount of time.
Dynatrace learns your typical service load over an observation period of one week.
required Database failed connectsdatabaseConnections databaseConnections Alert if the number of failed database connects within the specified time exceeds the specified absolute threshold:
required
The responseTime object Property Type Description Required Detect response time degradationsenabled boolean - required Detection mode for response time degradationsdetectionMode enum The element has these enums required autoDetectionresponseTimeAuto - required fixedDetectionresponseTimeFixed - required
The failureRate object Property Type Description Required Detect increases in failure rateenabled boolean - required Detection mode for increases in failure ratedetectionMode enum The element has these enums required autoDetectionfailureRateAuto Alert if the percentage of failing service calls increases by both the absolute and relative thresholds:
required fixedDetectionfailureRateFixed Alert if a given failure rate is exceeded during any 5-minute-period
required
The loadDrops object Property Type Description Required Detect service load dropsenabled boolean - required ThresholdloadDropPercent float - required Time spanminutesAbnormalState integer - required
The loadSpikes object Property Type Description Required Detect service load spikesenabled boolean - required ThresholdloadSpikePercent float - required Time spanminutesAbnormalState integer - required
The databaseConnections object Property Type Description Required Detect failed database connectsenabled boolean - required ThresholdmaxFailedConnects integer - required Time spantimePeriod integer - required
The responseTimeAuto object Property Type Description Required All requestsresponseTimeAll responseTimeAutoAll Alert if the median response time of all requests degrades beyond both the absolute and relative thresholds:
required Slowest 10%responseTimeSlowest responseTimeAutoSlowest Alert if the response time of the slowest 10% of requests degrades beyond both the absolute and relative thresholds:
required Avoid over-alertingoverAlertingProtection overAlertingProtection - required
The responseTimeFixed object Property Type Description Required All requestsresponseTimeAll responseTimeFixedAll Alert if the median response time of all requests degrades beyond this threshold within an observation period of 5 minutes:
required Slowest 10%responseTimeSlowest responseTimeFixedSlowest Alert if the response time of the slowest 10% of requests degrades beyond this threshold within an observation period of 5 minutes:
required Avoid over-alertingoverAlertingProtection overAlertingProtection - required Sensitivitysensitivity enum The element has these enums required
The failureRateAuto object Property Type Description Required Absolute thresholdabsoluteIncrease float - required Relative thresholdrelativeIncrease float - required Avoid over-alertingoverAlertingProtection overAlertingProtection - required
The failureRateFixed object Property Type Description Required Thresholdthreshold float - required Avoid over-alertingoverAlertingProtection overAlertingProtection - required Sensitivitysensitivity enum The element has these enums required
The responseTimeAutoAll object Property Type Description Required Absolute thresholddegradationMilliseconds float - required Relative thresholddegradationPercent float - required
The responseTimeAutoSlowest object Property Type Description Required Absolute thresholdslowestDegradationMilliseconds float - required Relative thresholdslowestDegradationPercent float - required
The overAlertingProtection object Property Type Description Required Only alert if there are at leastrequestsPerMinute float - required Only alert if the abnormal state remains for at leastminutesAbnormalState integer - required
The responseTimeFixedAll object Property Type Description Required ThresholddegradationMilliseconds float - required
The responseTimeFixedSlowest object Property Type Description Required ThresholdslowestDegradationMilliseconds float - required