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 |