Why is the performance of ARC slow sometimes?

Why is the performance of ARC slow sometimes?

The performance of ARC depends on the aspects like Tomcat's memory settings, physical RAM and also the indexes etc, you can verify the indexes in the admin db as follows. Try adding the following indexes into the admin db: > CREATE INDEX idx_moduleid_001 ON ADMIN_MAP_DEP_ROLE_USER_PRIV(MODULE_ID); > CREATE INDEX idx_maxlevel_001 ON ADMIN_MAP_DEP_ROLE_USER_PRIV(MAX_LEVEL); > CREATE INDEX idx_module_001 ON ADMIN_KPI_GROUP_MODULE(MODULE_ID); > CREATE INDEX idx_group_001 ON ADMIN_KPI_GROUP_MODULE(GROUP_ID); > CREATE INDEX idx_kpi_001 ON ADMIN_KPI_GROUP_MODULE(KPI_ID) > CREATE INDEX idx_kpi_002 ON ADMIN_KPIVIEWDETAIL(KPI_ID) . Attached the ARC optimization parameters list. Note: This belongs to the advanced configuration, please consult support team before doing the changes.

    • Related Articles

    • The application performance is very slow

      a) Ensure that there are no KPIs or graphs trying to retrieve data and inturn the system went unresponsive b) Also check if there are any idle connections to the database. These idle connections should be deleted from database.

    • Why is the application performance very slow?

      Ensure the following: a. There are no processes running in the background. For example, some KPIs or graphs trying to retrieve data. b. Terminate idle connections to the database. These two cases can make your application run slower. This is advanced ...

    • ARC Instance experienced slow; how to make sure that the ARC instance parameters are already optimised?

      Attached the ARC optimization parameters list, have it verified and do the necessory changes. Note: Before doing the changes consult global support team and take the necessary help wherever required, Along with this parameters verification one more ...

    • Application performance is very slow. What could be the reason for this?

      Cross-verify if this is across all business users or if the slow performance is specific to individual machine where ARC is accessed. It is always recommended to have a regular, scheduled restart of Tomcat services and maintenance of admin DB ...

    • How to improve the performance of ARC application?

      The resolution specified below is one among many, as the performance of ARC depends on several other aspects like Tomcat's memory settings, physical RAM etc. In cases where ARC is slow to be accessed, try adding the below-mentioned indexes into the ...