Docs Menu
Docs Home
/
MongoDB Cloud Manager
/
Manage Deployments

Calculate Suggested Indexes

On this page

  • Prerequisites
  • Procedure

Note

Available only with Cloud Manager Premium. This feature is available only with Cloud Manager Premium, which comes with certain MongoDB subscriptions. Contact MongoDB for more information.

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

Prerequisites

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

  • Enable database profiling for the MongoDB process.

  • Ensure that the profiler has data. If profiling is enabled, but no profiling data has yet been collected, Cloud Manager cannot suggest indexes.

Procedure

To edit the deployment's configuration:

1

In MongoDB Cloud Manager, go to the Deployment page for your project.

  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's not already displayed, select your desired project from the Projects menu in the navigation bar.

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

    The Deployment page displays.

2

Go to the Processes page.

Click the Processes tab for your deployment.

The Processes page displays.

3

Select the Clusters view for your deployment.

4

Click a deployment.

5

(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.
6

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

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

7

Click the Profiler tab above the charts.

8

Click the Calculate Suggested Indexes link above the chart.

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

9

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:

Back

Manage BI Connector in

Next

Edit a Replica Set

On this page