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)

KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , How To