2489254 - Slow load process done from DSO to infoproviders - SAP BW on ASE | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

2489254 - Slow load process done from DSO to infoproviders - SAP BW on ASE

Symptom

  • Performance issue reporting on loading data from DSO to Infoproviders in package creation.
  • The SYBASE_USE_FACT_TABLE_HINT_DSO = ' ' (SAP Note 2220667) was configured like that as per SAP request, but the performance issue is also reported even when this parameter is enabled.
  • The SAP Note 2189096 - SYB: Extended parallel query support" is implemented on your system
  • The BW Correction Collection SAP Note is also implemented on last version (see SAP Note # in the "See Also" section of this document)
  • Default Data Cache is correctly configured in order to have 80% allocated for the 128K I/O pool and the rest for the 16K I/O pool (See recommendation in the Best Practices Guide attached to the SAP Note 1680803 - page 46)
  • the SQL code which is consuming most execution time was captured from ASE monitoring using sp_showplan(<spid>) command -on an isql session-

Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 15.7 and 16.0 for Business Suite
  • SAP Business Warehouse - All versions 

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0 ; SAP Business Warehouse all versions

Keywords

KBA , BW-SYS-DB-SYB , BW on Sybase ASE Database Platform , Problem

About this page

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

Search for additional results

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