Remedy - ITSM -Recommended database indexes to improve performance of the Overview Console

Knowledge Article

Remedy - ITSM -Recommended database indexes to improve performance of the Overview Console
Remedy - ITSM -Recommended database indexes to improve performance of the Overview Console
BMC Helix IT Service Management OnPrem
BMC Remedy IT Service Management Suite

This  Knowledge Article applies to 7.6.04 and 8.x.
The recommended Indexes are included in ITSM 9.0.   But if you are experiencing a performance issue,  check to be sure they exist.

Implement the following index recommendations. Depending on what release you are on, you may have some of the recommended indexes in place already.
The important thing is make sure ID Field(Owner, Assignee, etc..) is the first column and STATUS is the second column in the composite index.

 
This knowledge article may contain information that does not apply to version 21.05 or later which runs in a container environment. Please refer to Article Number 000385088 for more information about troubleshooting BMC products in containers.

Legacy ID:KA402577

Please note, the base table name of a Remedy form varies from one installation to the other and it is in the format of T1234, where 1234 is the Remedy form’s schemaID.  In this document,  we use ????  to represent the Remedy form’s SchemaID.  
Use Developer Studio to modify/create indexes.

 
HPD:Help Desk
a) Modify the existing index I????_1000000427_1 on HPD:Help Desk form so that it becomes a composite index with Status as the second field.
FIELDNAME
 
FIELDID
COLUMN POSITION
Owner Group ID
1000000427
1
Status
7
3
Assigned Group ID
1000000079
2
LookupKeyword
230000009
4
Company
1000000001
5
.

 

b) Modify the existing index I????_4_1 on HPD:Help Desk so that it becomes a composite index.
FIELDNAME
FIELDID
COLUMN POSITION
Assignee Login ID
4
1
Status
7
2
Owner Login ID
1000000716
3
LookUpKeyword
230000009
4
Out of box, this index was built on field C4 only.


 
c) Modify the existing index I????_1000000079_1 on HPD:Help Desk so that it becomes a composite index.
FIELDNAME
FIELDID
COLUMN POSITION
Assigned Group ID
1000000079
1
Status
7
2
Out of box, this index was built on field 1000000079 only.


 
d) Modify the existing index I????_ 1000000716_1 on HPD:Help Desk so that it becomes a composite index.
FIELDNAME
FIELDID
COLUMN POSITION
Owner Login ID
1000000716
1
Status
7
2
Out of box, this index was built on field 1000000716 only.


 
CHG:Infrastructure Change
a) Modify the existing index I????_1000000408_1 on CHG:Infrastructure Change form so that it becomes a composite index 
FIELDNAME
FIELDID
COLUMN POSITION
CAB Manager Login
1000000408
1
Status
7
2
Out of box, this index was built on field C1000000408 only.


 
b) Modify the existing index I????_3234_1 on CHG:Infrastructure Change so that it becomes a composite index.               
FIELDNAME
FIELDID
COLUMN POSITION
Assigned Group ID
1000003234
1
Status
7
2
Out of box, this index was built on field C1000003234 only.


 
c) Modify the existing index I????_1000000079_1 on CHG:Infrastructure Change so that it becomes a composite index.
FIELDNAME
FIELDID
COLUMN POSITION
Support Group ID
1000000079
1
Status
7
2
Out of box, this index was built on field 1000000079 only.


 
d) Add index I????_ 1000003231_1 on CHG:Infrastructure Change.
FIELDNAME
FIELDID
COLUMN POSITION
Assigned Login ID
1000003231
1
Status
7
2


 
e) Add index I????_ 1000003259_1 on CHG:Infrastructure Change.
FIELDNAME
FIELDID
COLUMN POSITION
ChgImpGrpID
1000003259
1
Status
7
2
 

There are other forms used by the Overview Console that may also need the same type of changes, such as WOI:WorkOrder, TMS:Task, AAS:Activity, AST:CI Unavailability, AST:PurchaseRequisition, RMS:Release, PBM:Known Error, PBM:Problem Investigation, and PBM:Solution Database
 
Related Products:
  1. BMC Remedy IT Service Management Suite
BMC Helix IT Service Management OnPrem
BMC Remedy IT Service Management Suite
BMC Helix IT Service Management OnPrem
BMC Remedy IT Service Management Suite
Attachment(s):