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 Adaptive Server Enterprise , 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.