SAP Knowledge Base Article - Public

3384153 - View persistency poor performance in SAP Datasphere


When persisting view's data in SAP Datasphere, extracting data from ODP source takes longer, for example from an ADSO.

ODP Extraction jobs (ODQR_20XXXXXX_XXXXXX_000000_F) takes longer to finish.


SAP Datasphere


The extreme long running of persistence job might be caused by CDC Batch Size configuration.


To speed up the extraction job, consider to increase the value of CDC Batch Size, for instance 50MB or 100MB in case the DPAgent has the memory capacity.

Refer to Best Practices and Sizing Guide for Smart Data Integration when used in SAP Data Warehouse Cloud for more sizing details.

In case the issue impacts only a particular view, it's recommended to set up a new dedicated Datasphere's connection with the recommended larger batch size to persist this view.


long running, job , KBA , DS-DI-VIW , View Persistency and Runtime , How To


SAP Datasphere all versions