Smart IT performance tuning recommendations

This topic describes performance tuning recommendations for the following components:

Smart IT

You must apply BMC Remedy with Smart IT 1.2 Patch 1 to your environment to achieve these results. For more information, see 1.2.00.001: Patch 1

MongoDB

Enable Elasticsearch on the secondary MongoDB databases.

AR System server

BMC Remedy with Smart IT utilizes a significant amount of FTS searching. It is critical that you apply the FTS Fortification fix to reduce CPU usage on the AR Server and achieve optimal performance and scalability. For more information on the FTS fortification fix please refer to the following BMC Communities blog:

https://communities.bmc.com/community/bmcdn/bmc_atrium_and_foundation_technologies/bmc_remedy_ar_system/blog/2013/08/30/the-pulse-fts-fortification

BMC also recommends that you set the FTS threshold to 2000 to improve Smart IT searching performance.

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 position	Field ID	Field name
1	1000003231	ASLOGID
2	7	STATUS

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

Column position	Field ID	Field name
1	100003231	ASLOGID
2	7	STATUS

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

https://kb.bmc.com/infocenter/index?page=content&id=S:KA402577

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 position	Field ID	Field name
1	400130900	Source.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.