SAP Knowledge Base Article - Preview

3153053 - Configuration parameter 'optimize temp table resolution' - SAP ASE


  • How does configuration parameter 'optimize temp table resolution' take effect ?
  • Is there an example to show how 'optimize temp table resolution' works ?
  • Is there an equivalent in older releases of ASE ?

  • Performance issues and high CPU can be seen when 'optimize temp table resolution' is not on when it is beneficial.
  • Indicators of that include :
    • During (very) frequent execution of a procedure from multiple connections
      • sysprocesses 'cmd' column showing as 'COMPILING' and CPU utilisation very high
      • up to 100%
    • In sp_sysmon 'Procedure Cache Mangement' section
      • under 'Recompilation Reasons'
      • the value for 'Temporary Table Missing' is (very) high



SAP Adaptive Server Enterprise (ASE)


SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0


KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , 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.