- Manage Deployments >
- Calculate Suggested Indexes
Calculate Suggested Indexes¶
On this page
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
Click the calculate suggested indexes link above the chart.¶
The calculate suggested indexes link will not appear if the Prerequisites have not been met.
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:
- Index Creation in the MongoDB manual, or
- Create Indexes with Automation (if available on your account).