This documentation supports the 1.6 version of Remedy with Smart IT.

To view the latest version, select the version from the Product version menu.

Smart IT performance tuning recommendations

This topic describes performance tuning recommendations for the following components:

Smart IT database

Recommendations for global search

To improve global searches, the following values were set in the Configuration_Params table after upgrade. These values are set by default during a fresh install.

Configuration parameterValue
isExclude_TAG_and_CI_IDtrue
useLeadingSearchForAssettrue

BMC Remedy ITSM MSSQL and Oracle database

The following indexes are common to both MSSQL and Oracle databases.

Recommendations for the Ticket Console

The following indexes were added to improve performance and will be provided in the next service pack for the current release of BMC Remedy IT Service Management (ITSM) and incorporated into the next full release.

On the SRM:Request form, composite index 1000003231_1 was added:

Column positionField IDField name
11000003231ASLOGID
27STATUS

On the WOI:Workorder form, composite index 100003231_1 was added:

Column positionField IDField name
1100003231ASLOGID
27STATUS

Also refer to the following the knowledge article for index recommendations to support console searches:

https://selfservice.bmc.com/casemgmt/sc_KnowledgeArticle?sfdcid=kA214000000d8UZCAY&type=Solution

These index changes have been incorporated into the product starting in BMC Remedy ITSM 8.1 SP2.

Recommendation for displaying asset details

The following index was added to improve performance and will be provided in the next service pack for the current release of BMC Remedy ITSM and incorporated into the next full release.

On the BMC.Core:BMC_BaseRelationship form, index C400130900_1 was added:

Column positionField IDField name
1400130900Source.ReconciliationIdentity

There should be a delivered index on Destination.ReconciliationIdentity. Depending on your release, there might not be an index; in that case, create one.

Recommendations for Collision and Calendar request

When creating change request, if you notice that the SQL query is taking high response time for Collision and Calendar request, you can apply the following index to improve performance. You might experience performance issues if you are using BMC Remedy ITSM version prior to 9.1 Service pack 1 (9.1.01). This index will help you to avoid full table scan for the table 'CHG:Infrastructure Change'.

On the CHG:Infrastructure Change form, create a non-unique index on the field Scheduled End Date.

From BMC Remedy Developer Studio, create an overlay of the CHG:Infrastructure Change form, and add an index on the field Scheduled End Date.

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

Comments

  1. Shayne Froelich

    What if the values do not exist in the Configuration_Parameter database in Smart IT? I can manually add the name and value, but I don't know what needs to be added for the ID.

    Aug 22, 2017 08:17
  2. Brad Taylor

    It would be very useful to document when (version) each of these performance improvements were added to the base system. The changes suggested by the May 31, 2017 version of this page are already present in ITSM 9.1 SP3 and Smart IT 1.6.00.

    Aug 22, 2017 01:36
  3. Nilay Agambagis

    Hello Brad,

    Thanks for your comment. I will communicate with the concerned SME and will get back to you.

    Regards,

    Nilay

    Aug 30, 2017 09:39
  4. Nilay Agambagis

    Hello Shayne,

    The configuration parameters are available in the 'Smart_it_db_business':

    Smart _IT_DB > Smart_it_db_business > CONFIGURATION_PARAMS

    When adding the configuration parameter manually in the database, you can put any unique ID.

     

    Regards,

    Nilay

    Aug 30, 2017 09:42
  5. Francois Seegers

    Why still recommending FTS Fortification if it only applies to the following minimum versions; 7.6.04 SP2, 8.0 patch 3 and 8.1 base versions and version 1.6 of Smart IT only support 9.x AR?

    Aug 10, 2018 11:56
    1. Nilay Agambagis

      Hello Francois,

      Thanks a lot for your comment.

      We are communicating with the SME on this. I will get back to you as soon as I get a reply from them.

      Regards,

      Nilay Agambagis

      Jan 28, 2019 01:16
    1. Dhanya Menon

      Hi Francois,

      We have updated this page and removed the section about FTS Fortification.

      Thanks,

      Dhanya Menon

      Mar 18, 2019 06:11