TESTDATRNRPARTx tables. Bad performance

[Former Member]

Hi experts:

    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

BR,

Abel López

[former_member181999]

Hello Abel,

Please try checking the below areas

1. Join condition applied
2. SQL / ABAP / Coding used
3. Check weather you followed following -6 Golden Rules For HANA objects development.

Regards-Ashok

[Former Member]

Thanks for your answer Ashok, but these are standard SAP tables (Request joint tables) not views, so you can not modified join condition applied.

Thanks anyway,

BR,

Abel