Symptom
- 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
- During (very) frequent execution of a procedure from multiple connections
Read more...
Environment
SAP Adaptive Server Enterprise (ASE)
Product
SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0
Keywords
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.