- 1. Are the users LDAP users or they have static authentication in User form (with password defined)? You can check Authentication Server field in mid-tier. If AREA LDAP authentication takes longer under load it will impact login time for the users.
- 2. Check arexception.log in all AR nodes at peak hours. Do you see api or sql calls taking long time?
- 3. Check mid-tier parameters as documented under https://communities.bmc.com/docs/DOC-48031 to make sure MT is not the bottleneck.
Thanks for the reply.
I think what cause the slowness performance is the sql query from the remedy, so i just need to change all the expensive query just 'Like' function with some kind like equal.