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 |
| SERVICE_METHOD - RequestSERVICE - ServiceHOST_GROUP - Host Groupenvironment |
Parameters
| Property | Label | Type | Description | Required |
|---|---|---|---|---|
| responseTime | Response time | responseTime | - | required |
| failureRate | Failure rate | failureRate | - | required |
| loadDrops | 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 |
| loadSpikes | 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 |
| databaseConnections | Database failed connects | databaseConnections | Alert if the number of failed database connects within the specified time exceeds the specified absolute threshold: | required |
Request body objects
The loadSpikes object
| Property | Label | Type | Description | Required |
|---|---|---|---|---|
| enabled | Detect service load spikes | boolean | - | required |
| loadSpikePercent | Threshold | float | - | required |
| minutesAbnormalState | Time span | integer | - | required |
The loadDrops object
| Property | Label | Type | Description | Required |
|---|---|---|---|---|
| enabled | Detect service load drops | boolean | - | required |
| loadDropPercent | Threshold | float | - | required |
| minutesAbnormalState | Time span | integer | - | required |
The overAlertingProtection object
| Property | Label | Type | Description | Required |
|---|---|---|---|---|
| requestsPerMinute | Only alert if there are at least | float | - | required |
| minutesAbnormalState | Only alert if the abnormal state remains for at least | integer | - | required |
The failureRateFixed object
| Property | Label | Type | Description | Required |
|---|---|---|---|---|
| threshold | Threshold | float | - | required |
| overAlertingProtection | Avoid over-alerting | overAlertingProtection | - | required |
| sensitivity | Sensitivity | enum | - | required |
The failureRateAuto object
| Property | Label | Type | Description | Required |
|---|---|---|---|---|
| absoluteIncrease | Absolute threshold | float | - | required |
| relativeIncrease | Relative threshold | float | - | required |
| overAlertingProtection | Avoid over-alerting | overAlertingProtection | - | required |
The failureRate object
| Property | Label | Type | Description | Required |
|---|---|---|---|---|
| enabled | Detect increases in failure rate | boolean | - | required |
| detectionMode | Detection mode for increases in failure rate | enum | - | required |
| autoDetection | - | failureRateAuto | Alert if the percentage of failing service calls increases by both the absolute and relative thresholds: | required |
| fixedDetection | - | failureRateFixed | Alert if a given failure rate is exceeded during any 5-minute-period | required |
The responseTimeAutoAll object
| Property | Label | Type | Description | Required |
|---|---|---|---|---|
| degradationMilliseconds | Absolute threshold | float | - | required |
| degradationPercent | Relative threshold | float | - | required |
The responseTimeAutoSlowest object
| Property | Label | Type | Description | Required |
|---|---|---|---|---|
| slowestDegradationMilliseconds | Absolute threshold | float | - | required |
| slowestDegradationPercent | Relative threshold | float | - | required |
The responseTimeAuto object
| Property | Label | Type | Description | Required |
|---|---|---|---|---|
| responseTimeAll | All requests | responseTimeAutoAll | Alert if the median response time of all requests degrades beyond both the absolute and relative thresholds: | required |
| responseTimeSlowest | Slowest 10% | responseTimeAutoSlowest | Alert if the response time of the slowest 10% of requests degrades beyond both the absolute and relative thresholds: | required |
| overAlertingProtection | Avoid over-alerting | overAlertingProtection | - | required |
The responseTimeFixedAll object
| Property | Label | Type | Description | Required |
|---|---|---|---|---|
| degradationMilliseconds | Threshold | float | - | required |
The responseTimeFixedSlowest object
| Property | Label | Type | Description | Required |
|---|---|---|---|---|
| slowestDegradationMilliseconds | Threshold | float | - | required |
The responseTimeFixed object
| Property | Label | Type | Description | Required |
|---|---|---|---|---|
| responseTimeAll | All requests | responseTimeFixedAll | Alert if the median response time of all requests degrades beyond this threshold within an observation period of 5 minutes: | required |
| responseTimeSlowest | Slowest 10% | responseTimeFixedSlowest | Alert if the response time of the slowest 10% of requests degrades beyond this threshold within an observation period of 5 minutes: | required |
| overAlertingProtection | Avoid over-alerting | overAlertingProtection | - | required |
| sensitivity | Sensitivity | enum | - | required |
The responseTime object
| Property | Label | Type | Description | Required |
|---|---|---|---|---|
| enabled | Detect response time degradations | boolean | - | required |
| detectionMode | Detection mode for response time degradations | enum | - | required |
| autoDetection | - | responseTimeAuto | - | required |
| fixedDetection | - | responseTimeFixed | - | required |
The databaseConnections object
| Property | Label | Type | Description | Required |
|---|---|---|---|---|
| enabled | Detect failed database connects | boolean | - | required |
| maxFailedConnects | Threshold | integer | - | required |
| timePeriod | Time span | integer | - | required |