We have serious performance issues with our BW Hana. System takes long time in several standard process, such us process chain, managing infocube and so on. Tracing this process, we notice that system spend almost all time deleting TESTDATRNRPARTx tables (request temporaly join tables). Other times, these issuses desappears restarting BW system but after a while system increase poor perfomance again. We must to know the core reason in order to solve it from now on.
Anybody knows what happend or if there is a job to clean automactly this tables?
We are on 7.31 SP 10 on Hana