Settings API - Anomaly detection for databases schema table

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 IDSchema groupsScope
builtin:anomaly-detection.databases
  • group:anomaly-detection
SERVICE_METHOD - Request
SERVICE - Service
HOST_GROUP - Host Group
environment
GETManagedhttps://{your-domain}/e/{your-environment-id}/api/v2/settings/schemas/builtin:anomaly-detection.databases
SaaShttps://{your-environment-id}.live.dynatrace.com/api/v2/settings/schemas/builtin:anomaly-detection.databases
Environment ActiveGatehttps://{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

PropertyTypeDescriptionRequired
Response time
responseTime
responseTime-required
Failure rate
failureRate
failureRate-required
Service load drops
loadDrops
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 spikes
loadSpikes
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 connects
databaseConnections
databaseConnections

Alert if the number of failed database connects within the specified time exceeds the specified absolute threshold:

required
The responseTime object
PropertyTypeDescriptionRequired
Detect response time degradations
enabled
boolean-required
Detection mode for response time degradations
detectionMode
enum
  • auto
  • fixed
required
autoDetectionresponseTimeAuto-required
fixedDetectionresponseTimeFixed-required
The failureRate object
PropertyTypeDescriptionRequired
Detect increases in failure rate
enabled
boolean-required
Detection mode for increases in failure rate
detectionMode
enum
  • auto
  • fixed
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
PropertyTypeDescriptionRequired
Detect service load drops
enabled
boolean-required
Threshold
loadDropPercent
float-required
Time span
minutesAbnormalState
integer-required
The loadSpikes object
PropertyTypeDescriptionRequired
Detect service load spikes
enabled
boolean-required
Threshold
loadSpikePercent
float-required
Time span
minutesAbnormalState
integer-required
The databaseConnections object
PropertyTypeDescriptionRequired
Detect failed database connects
enabled
boolean-required
Threshold
maxFailedConnects
integer-required
Time span
timePeriod
integer-required
The responseTimeAuto object
PropertyTypeDescriptionRequired
All requests
responseTimeAll
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-alerting
overAlertingProtection
overAlertingProtection-required
The responseTimeFixed object
PropertyTypeDescriptionRequired
All requests
responseTimeAll
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-alerting
overAlertingProtection
overAlertingProtection-required
Sensitivity
sensitivity
enum
  • low
  • medium
  • high
required
The failureRateAuto object
PropertyTypeDescriptionRequired
Absolute threshold
absoluteIncrease
float-required
Relative threshold
relativeIncrease
float-required
Avoid over-alerting
overAlertingProtection
overAlertingProtection-required
The failureRateFixed object
PropertyTypeDescriptionRequired
Threshold
threshold
float-required
Avoid over-alerting
overAlertingProtection
overAlertingProtection-required
Sensitivity
sensitivity
enum
  • low
  • medium
  • high
required
The responseTimeAutoAll object
PropertyTypeDescriptionRequired
Absolute threshold
degradationMilliseconds
float-required
Relative threshold
degradationPercent
float-required
The responseTimeAutoSlowest object
PropertyTypeDescriptionRequired
Absolute threshold
slowestDegradationMilliseconds
float-required
Relative threshold
slowestDegradationPercent
float-required
The overAlertingProtection object
PropertyTypeDescriptionRequired
Only alert if there are at least
requestsPerMinute
float-required
Only alert if the abnormal state remains for at least
minutesAbnormalState
integer-required
The responseTimeFixedAll object
PropertyTypeDescriptionRequired
Threshold
degradationMilliseconds
float-required
The responseTimeFixedSlowest object
PropertyTypeDescriptionRequired
Threshold
slowestDegradationMilliseconds
float-required