Recommendations

이 페이지는 아직 영어로 제공되지 않습니다. 번역 작업 중입니다.
현재 번역 프로젝트에 대한 질문이나 피드백이 있으신 경우 언제든지 연락주시기 바랍니다.

Database Monitoring (DBM) Recommendations draw attention to potential optimizations and problematic areas across your database fleet.

The Recommendations page in Datadog

How it works

Datadog analyzes metrics and sample data from DBM to identify your systems’ highest-priority issues. A severity indicator is calculated for each recommendation, highlighting the most impactful areas to focus on. High-severity recommendations may indicate immediate or impending problems, while lower-severity recommendations can be addressed asynchronously to proactively maintain database health.

Supported recommendation types

Recommendation TypeDescriptionMongoDBMySQLOraclePostgreSQLSQL Server
Function in FilterThe query calls a function on columns being filtered, leading to expensive sequential scans that can’t take advantage of typical column-based indexes.
High Impact BlockerThe query is causing a significant amount of waiting time for blocked queries.
High Row CountThe query returns a large number of rows in its result set.
Long Running QueryThe query has durations that have exceeded a threshold of 30 seconds.
Low Disk SpaceThe database instance is running low on disk space.

Note: Only available on Amazon RDS.
Missing IndexThe query’s execution plan performs expensive sequential scans. When detected, Datadog recommends using an index to expedite the query.
Unused IndexThe index has not been used in any execution plans recently.

Further reading

추가 유용한 문서, 링크 및 기사:

A deep dive into Database Monitoring index recommendationsBLOG more more