APM PERFORMANCE IMPROVEMENT TIP

Product(s):	APM Implementation and Performance Management
	Version(s):	All
	Environment:	N\A
	Area:	N/A
	Subarea:	N\A

Problem

When a user reports that they are facing slowness in performance for a specific MCLB configuration, may be that the SQL query is very complex.
For ex: The Asset Heath Index query was reported as being slow and query analysis identified that the filtering was problematic.

Solution

Solution: - To improve the performance, we can send the SQL query to the respective DBA and ask them to investigate or add indexes to the database.
In this case DBA recommended to remove the filters.

Alternatively, try not making the configuration with too many filters as the default configuration in MCLB

NOTE: - Try making the configurations less complex with less filters/ make the default configuration as simple as possible