SAP Knowledge Base Article - Preview

2285030 - What optimization goal to configure for Netweaver applications running on SAP ASE ?

Symptom

  • In SAP Note 1581695 - SYB: Configuration Guide for SAP ASE 16.0, the "optimization goal" parameters are specified as:
    "The optimization goal must be either "allrows_mix" or "sap_oltp" for systems that are not SAP BW Systems."
    "The optimization goal is recommended to be "allrows_mix" or "sap_oltp" for SAP BW Systems."

  • Clarification on sap_olap optimization goal:
    • Can sap_olap be configured as the optimization goal?


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 16.0 for Business Suite
  • SAP Business Warehouse (BW)
  • SAP Business Suite (BS)
  • SAP Netweaver (NW)

Product

SAP Adaptive Server Enterprise 16.0 ; SAP Business Warehouse all versions ; SAP NetWeaver Application Server for ABAP for SAP Business Suite all versions ; SAP NetWeaver all versions

Keywords

ASE, BW, optimization goal, sap_olap, sap_oltp, allrows_oltp, allrows_mix , KBA , BW-SYS-DB-SYB , BW on Adaptive Server Enterprise , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , How To

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.