This documentation supports the 19.08 version of BMC CMDB.

To view an earlier version, select the version from the Product version menu.

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 table displays the out-of-the-box indexes that must always exist in your system. 

BMC.CORE:BMC_BaseElementBMC.CORE:BMC_BaseRelationship
179179
400079600400079600
400131300400131300
400127400,400129200,400129100,1400127400,400129200,400129100,1
400131200400131200
530060100,6,400129100,400129200530060100,6,400129100,400129200

530060100,6,400129200

530060100,6,400129200
400129200,400129100400129200,400129100
240001002400131000,400130900
530060200,400127400490008000,490009100

530010100,400127400

490009000,490008100
 530060100,6,400127400,400129200
 490008000,490008100,1 
 490009000,490009100,1
 179,400129200,400079600,490009000,490008000,1
 400129200,490008000
 490008100,400128800
 400127400, 530060400, 530060500
 400130900

Before you begin

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

To create missing system indexes

Note

The following steps are for adding missing out-of-the-box system indexes only. To add or edit custom indexes, see Creating or modifying classes by using Class Manager.

  1. Login to the computer where BMC Developer Studio is installed.

  2. Open BMC Developer Studio.
  3. Select Base Development Mode.
    File > Switch Mode > Base Development

  4. Double-click Forms in the AR System Navigator.
  5. From 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 the BMC.CORE:BMC_BaseElement to open it.
  7. Click the Definitions tab at the bottom of the form window.
  8. In the Definitions tab, click the Indexes panel.

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

  9. Click New.
  10. Select the new index.
    1. To add fields to the index, click Add and complete the Field Selector dialog box for each field.
      • 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.
      • You can use the Remove and Remove All buttons to remove fields form the index.
  11. Save the form.

Repeat the above steps for the BMC.CORE:BMC_BaseRelationship form to add the missing indexes.

Was this page helpful? Yes No Submitting... Thank you

Comments