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

Version 1
    Share:|

    This document contains official content from the BMC Software Knowledge Base. It is automatically updated when the knowledge article is modified.


    PRODUCT:

    Remedy IT Service Management Suite


    APPLIES TO:

    BMC Remedy IT Service Management Suite



    PROBLEM:

     

    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.

      
        

     


    SOLUTION:

     

    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

     


    Article Number:

    000097157


    Article Type:

    Solutions to a Product Problem



      Looking for additional information?    Search BMC Support  or  Browse Knowledge Articles