Troubleshooting performance issues caused by missing CMDB indexes

This topic lists the out-of-the-box CMDB indexes that should always exist. If any index listed on this page is missing, it may lead to performance issues. To resolve any performance issue that may occur due to the missing index, you must add the missing index in the system.

List of out-of-the-box indexes

The following tables display the out-of-the-box indexes that must always exist in your system.

Before you begin

Before you modify system indexes, you must ensure that you have Developer Studio installed. For more information, see Developer Studio.

To create missing system indexes

Use this procedure to add missing out-of-the-box system indexes and custom indexes. 

1. Log in to the computer where Developer Studio is installed.
2. Open Developer Studio.
3. Select File > Switch Mode > Base Development
4. In the AR System Navigator, double-click Forms.
   
5. On the AR System Navigator tab, expand the source server and under All Objects select Forms.
   The Forms tab opens, listing all the AR forms.
6. In the Forms window, double-click BMC.CORE:BMC_BaseElement to open it.
   
7. Click the Definitions tab at the bottom of the form window.

8. On the Definitions tab, click Indexes.
   

   The existing indexes and the fields used in the indexes are listed.

9. Click New.

10. Select the new index and perform the following steps:

    • To add fields to the index, click Add and fill the required information in the Field Selector dialog box for each field.
    • To remove fields from the index, click Remove > Remove All buttons.

    Important

    • You can combine multiple fields into a composite index.
    • You can enter as many as 16 fields.
    • You should add the fields in the order you want them indexed, or you can use the Up and Down buttons to put them in the correct order.
    • Each indexed field must be less than or equal to 255 characters, but the composite Index can have a total length greater than 255.
11. Save the form.

Similarly, you can add the missing indexes to the BMC.CORE:BMC_BaseRelationship form.