SAP Knowledge Base Article - Preview

3309498 - Slowdown of BW query performance due to missing join relocation

Symptom

When a BW query is executed, a remote statement is running for a long time, reading from the NLS provider. Currently running remote statements can be retrieved using the following SQL statement:

SELECT * FROM M_REMOTE_STATEMENTS WHERE REMOTE_STATEMENT_STATUS = 'EXECUTING'

By observing the FETCHED_RECORD_COUNT, it can be verified that a large number of records is retrieved from the remote source.

"Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental." 


Read more...

Environment

  • SAP HANA, platform edition 2.0
  • SAP Business Warehouse
  • SAP BW/4HANA

Product

SAP BW/4HANA all versions ; SAP Business Warehouse all versions ; SAP HANA, platform edition 2.0

Keywords

KBA , HAN-DB-PERF , SAP HANA Database Performance , HAN-DB-ENG-BW , SAP HANA BW Engine , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.