Execution of RS2HANA_CHECK making SAP system slow
We are using BW on HANA model with BW 7.4 SP08 and HANA SP08.
We are using RS2HANA_CHECK tcode to generate HANA authorizations from BW. We normally run it in background as the execution takes time. But we have noticed whenever there is a BW dataload going on, at same if RS2HANA_CHECK is executed, it makes the system very slow.
For example, clicking on Manage button for an info provider in RSA1 normally takes 2 seconds to take to Manage window. But with both Dataload and RS2HANA_CHECK running together, it takes forever to take to Manage window. Even the background execution of RS2HANA_CHECK which normally gets over in 600-700 seconds, takes more than 20000 seconds (and still goes on. Most of the times we have to cancel the job).
Another issue we faced is that at such times, the users who access reports at front end, ended up getting errors.
Could anyone suggest if this is a known issue and what is the solution for this? I just wanted to check if any solution is available before raising it to SAP.