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 ID
Schema groups
Scope
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

Property
Type
Description
Required
Response time
responseTime
-
required
Failure rate
failureRate
-
required
Service load drops
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

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

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 degradations
enabled
boolean
-
required
Detection mode for response time degradations
detectionMode
enum
  • auto
  • fixed
required
autoDetection
-
required
fixedDetection
-
required
The failureRate object
Property
Type
Description
Required
Detect increases in failure rate
enabled
boolean
-
required
Detection mode for increases in failure rate
detectionMode
enum
  • auto
  • fixed
required
autoDetection

Alert if the percentage of failing service calls increases by both the absolute and relative thresholds:

required
fixedDetection

Alert if a given failure rate is exceeded during any 5-minute-period

required
The loadDrops object
Property
Type
Description
Required
Detect service load drops
enabled
boolean
-
required
Threshold
loadDropPercent
float
-
required
Time span
minutesAbnormalState
integer
-
required
The loadSpikes object
Property
Type
Description
Required
Detect service load spikes
enabled
boolean
-
required
Threshold
loadSpikePercent
float
-
required
Time span
minutesAbnormalState
integer
-
required
The databaseConnections object
Property
Type
Description
Required
Detect failed database connects
enabled
boolean
-
required
Threshold
maxFailedConnects
integer
-
required
Time span
timePeriod
integer
-
required
The responseTimeAuto object
Property
Type
Description
Required
All requests
responseTimeAll

Alert if the median response time of all requests degrades beyond both the absolute and relative thresholds:

required
Slowest 10%
responseTimeSlowest

Alert if the response time of the slowest 10% of requests degrades beyond both the absolute and relative thresholds:

required
Avoid over-alerting
overAlertingProtection
-
required
The responseTimeFixed object
Property
Type
Description
Required
All requests
responseTimeAll

Alert if the median response time of all requests degrades beyond this threshold within an observation period of 5 minutes:

required
Slowest 10%
responseTimeSlowest

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
-
required
Sensitivity
sensitivity
enum
  • low
  • medium
  • high
required
The failureRateAuto object
Property
Type
Description
Required
Absolute threshold
absoluteIncrease
float
-
required
Relative threshold
relativeIncrease
float
-
required
Avoid over-alerting
overAlertingProtection
-
required
The failureRateFixed object
Property
Type
Description
Required
Threshold
threshold
float
-
required
Avoid over-alerting
overAlertingProtection
-
required
Sensitivity
sensitivity
enum
  • low
  • medium
  • high
required
The responseTimeAutoAll object
Property
Type
Description
Required
Absolute threshold
degradationMilliseconds
float
-
required
Relative threshold
degradationPercent
float
-
required
The responseTimeAutoSlowest object
Property
Type
Description
Required
Absolute threshold
slowestDegradationMilliseconds
float
-
required
Relative threshold
slowestDegradationPercent
float
-
required
The overAlertingProtection object
Property
Type
Description
Required
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
Property
Type
Description
Required
Threshold
degradationMilliseconds
float
-
required
The responseTimeFixedSlowest object
Property
Type
Description
Required
Threshold
slowestDegradationMilliseconds
float
-
required