I need help on Sybase Database parameter "number of open indexes".
While analyzing MIRO performance issue, we found that above parameter is reaching its limit.
I would like to know, if my observation is correct and will help in improving MIRO transaction performance.
Before this, we have done following changes for MIRO performance issue as recommended by SAP, but did not helped:
Pls. reply with your expert comments on above and also if any suggestions on improving performance of MIRO transaction as early as possible.
P.S: attaching sp_monitorconfig "all" output of production server for your ready reference.