Docs Menu

Docs HomeMongoDB Ops Manager

Calculate Suggested Indexes

On this page

  • Prerequisites
  • Procedure

Ops Manager can analyze the data on query patterns collected by the database profiler and suggest a set of indexes that could improve query performance. Ops Manager scores each suggested index on its expected benefit.

For Ops Manager to suggest indexes, the following must be true:

  • You must enable database profiling for the MongoDB process. See Profile Databases.

  • The profiler must have data. If profiling is enabled, but no profiling data has yet been collected, Ops Manager cannot suggest indexes.

To edit the deployment's configuration:

1
  1. If it is not already displayed, select the organization that contains your desired project from the Organizations menu in the navigation bar.

  2. If it is not already displayed, select your desired project from the Projects menu in the navigation bar.

  3. If it is not already displayed, click Deployment in the sidebar.

  1. Click the Clusters view.

2
3

The four buttons are listed in the following order, left to right: Shards, Configs, Mongos, and BIs.

Process
Displays
Shards
mongod processes that host your data.
Configs
mongod processes that run as config servers to store a sharded cluster's metadata.
Mongos
mongos processes that route data in a sharded cluster.
BIs
BI processes that access data in a sharded cluster.
4

For shared clusters, you must first click the shard that contains the process.

5
6

The calculate suggested indexes link will not appear if the Prerequisites have not been met.

7

For instructions on adding an index to a MongoDB process, see either:

←  Manage BI Connector in Ops ManagerEdit a Replica Set →