Atlas managed slow operation threshold and Performance Advisor index suggestions
Parent: Database Profiler vs Query Profiler · Published reference · snapshot 2026-10-30
↓ Facts as markdownall context files
Source-anchored research for Atlas managed slow operation threshold and Performance Advisor index suggestions. Run status: COMPLETED.
These notes link each claim to its source. Some citations identify archived research reports that are no longer hosted on this site. A published reference means the content is available; it does not certify independent review or accuracy.Read the editorial policy and follow the sources before relying on a claim.
Measurements and reference values
- MongoDB advises against fixed thresholds below 100 ms; a OneUptime tutorial instead illustrates 50 ms after disabling management, so its example should not be treated as MongoDB recommended practice. (medium confidence) (verified as of 2026-03-31) [source]
Problems, failure modes and limitations
- Atlas enables managed slow-operation thresholds by default on supported clusters and dynamically adjusts them using execution times across the cluster; 100 ms is the fixed fallback when management is disabled. (medium confidence) (verified as of 2026-10-14) [source]
- A 2022 support response says query frequency affects suggestions, so infrequent slow queries need not produce recommendations. (low confidence) [source]
- MongoDB Atlas Query Insights templates read Performance Advisor slow logs and suggestions to report on query shapes; the template cannot create indexes. (low confidence) (verified as of 2026-10-30) [source]
- Inference for safe index removal: absence of an Advisor suggestion cannot prove safety because recommendations depend on query frequency and captured slow-log evidence. (medium confidence) [source]
- The project-level Managed Slow Operations toggle and the CLI commands atlas performanceAdvisor slowOperationThreshold disable and enable control automatic threshold management. (medium confidence) (verified as of 2026-10-14) [source]
- Performance Advisor suggests indexes for slow queries and includes sample queries grouped by query shape. (medium confidence) (verified as of 2026-10-14) [source]
- Atlas does not support the managed slow-operation threshold on clusters with MongoDB Search enabled, and Free clusters cannot enable it. (low confidence) (verified as of 2026-10-14) [source]
- Inference: absence of an index suggestion cannot establish workload-wide safety for an index change, because recommendations depend on observed slow operations and log coverage. (medium confidence) (verified as of 2026-10-14) [source]
Comparisons and alternatives
- Performance Advisor suggests indexes from observed slow queries; suggestions reflect captured workload rather than every possible query. (medium confidence) (verified as of 2026-10-30) [source]
Facts and statements
- Review write costs before adding suggested indexes; maintaining more indexes can reduce write performance. (medium confidence) [source]
- Suggestions include sample query shapes and impact ranking based on wasted bytes read. (medium confidence) (verified as of 2026-10-30) [source]
- Extreme log volume can interrupt Advisor log collection; downloadable logs remain complete. (low confidence) (verified as of 2026-10-30) [source]
- Managed thresholds are unsupported with MongoDB Search enabled; Performance Advisor requires M10+. (low confidence) (verified as of 2026-10-30) [source]
- In a worked Java application example, requests filtering movies by title and year produced an Advisor suggestion for {title: 1, year: 1}. This illustrates workload-driven suggestions, not a general benchmark. (low confidence) [source]
- Performance Advisor is available on M10+ clusters; recommendations consider replica-set workload activity including secondaries. (low confidence) (verified as of 2026-10-14) [source]
- Suggested-index metrics include execution frequency, average execution time and documents examined per document returned; Impact ranks suggestions by wasted bytes read. (low confidence) (verified as of 2026-10-14) [source]
- Before creating another index, weigh its write cost and query frequency, and consider whether existing indexes can serve a modified query. (medium confidence) (verified as of 2026-10-14) [source]
- Index-suggestion coverage has limits: time-series collections receive no performance suggestions, and extreme log volume can interrupt Atlas log collection for these interfaces; downloadable logs remain complete. (low confidence) (verified as of 2026-10-14) [source]
- For its own log-based compatibility analysis, AWS documents disabling Atlas threshold management, enabling full logging with db.setProfilingLevel(0, -1), then restoring managed operation afterward; it warns of overhead and recommends dev/test capture. (low confidence) (verified as of 2026-10-30) [source]
Children
- No children recorded.