• Home
  • Dynatrace API
  • Environment
  • Settings
  • Schemas
  • Anomaly detection for databases

Settings 2.0 - Anomaly detection for databases schema

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
Retrieve schema via Settings API
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

PropertyLabelTypeDescriptionRequired
responseTimeResponse timeresponseTime-required
failureRateFailure ratefailureRate-required
loadDropsService load dropsloadDrops

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
loadSpikesService load spikesloadSpikes

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
databaseConnectionsDatabase failed connectsdatabaseConnections

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

required

Request body objects

The loadSpikes object
PropertyLabelTypeDescriptionRequired
enabledDetect service load spikesboolean-required
loadSpikePercentThresholdfloat-required
minutesAbnormalStateTime spaninteger-required
The loadDrops object
PropertyLabelTypeDescriptionRequired
enabledDetect service load dropsboolean-required
loadDropPercentThresholdfloat-required
minutesAbnormalStateTime spaninteger-required
The overAlertingProtection object
PropertyLabelTypeDescriptionRequired
requestsPerMinuteOnly alert if there are at leastfloat-required
minutesAbnormalStateOnly alert if the abnormal state remains for at leastinteger-required
The failureRateFixed object
PropertyLabelTypeDescriptionRequired
thresholdThresholdfloat-required
overAlertingProtectionAvoid over-alertingoverAlertingProtection-required
sensitivitySensitivityenum-required
The failureRateAuto object
PropertyLabelTypeDescriptionRequired
absoluteIncreaseAbsolute thresholdfloat-required
relativeIncreaseRelative thresholdfloat-required
overAlertingProtectionAvoid over-alertingoverAlertingProtection-required
The failureRate object
PropertyLabelTypeDescriptionRequired
enabledDetect increases in failure rateboolean-required
detectionModeDetection mode for increases in failure rateenum-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
PropertyLabelTypeDescriptionRequired
degradationMillisecondsAbsolute thresholdfloat-required
degradationPercentRelative thresholdfloat-required
The responseTimeAutoSlowest object
PropertyLabelTypeDescriptionRequired
slowestDegradationMillisecondsAbsolute thresholdfloat-required
slowestDegradationPercentRelative thresholdfloat-required
The responseTimeAuto object
PropertyLabelTypeDescriptionRequired
responseTimeAllAll requestsresponseTimeAutoAll

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

required
responseTimeSlowestSlowest 10%responseTimeAutoSlowest

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

required
overAlertingProtectionAvoid over-alertingoverAlertingProtection-required
The responseTimeFixedAll object
PropertyLabelTypeDescriptionRequired
degradationMillisecondsThresholdfloat-required
The responseTimeFixedSlowest object
PropertyLabelTypeDescriptionRequired
slowestDegradationMillisecondsThresholdfloat-required
The responseTimeFixed object
PropertyLabelTypeDescriptionRequired
responseTimeAllAll requestsresponseTimeFixedAll

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

required
responseTimeSlowestSlowest 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
overAlertingProtectionAvoid over-alertingoverAlertingProtection-required
sensitivitySensitivityenum-required
The responseTime object
PropertyLabelTypeDescriptionRequired
enabledDetect response time degradationsboolean-required
detectionModeDetection mode for response time degradationsenum-required
autoDetection-responseTimeAuto-required
fixedDetection-responseTimeFixed-required
The databaseConnections object
PropertyLabelTypeDescriptionRequired
enabledDetect failed database connectsboolean-required
maxFailedConnectsThresholdinteger-required
timePeriodTime spaninteger-required