Navigation
This version of the documentation is archived and no longer supported. It will be removed on 01 March 2021. To learn how to upgrade your version of MongoDB Ops Manager, refer to the upgrade documentation.
You were redirected from a different version of the documentation. Click here to go back.

Calculate Suggested Indexes

Overview

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.

Prerequisites

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.

Procedure

To edit the deployment’s configuration:

1

Click Deployment, then the Processes tab, then the Topology view.

2

Click a deployment.

3

(Optional) For sharded clusters, filter which process type is listed.

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

Click the process for which you want to calculate suggested indexes.

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

5

Click the Profiler tab above the charts.

6
7

Copy the indexes you want to create and add them to the MongoDB process.

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