Navigation
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

If the process is part of a sharded cluster, click the filter button for the type of process.

Click one of the following:

Shards Displays the mongod processes that host your data.
Configs Displays the mongod processes that run as config servers to store a sharded cluster’s metadata.
Mongos Displays the mongos processes that route data in a sharded cluster.
3

On the line listing the process, click Metrics.

4

Click the Profiler tab above the charts.

5
6

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: