- The conserve_tempdb_space optimization criteria does not work in a scenario when all plans required large tempdb space. it is possible to have a query use all the tempdb space and filled the tempdb even with the conserve_tempdb_space is set to 'on'.
- Use resource governor for tempdb_space can terminate the connection during execution.
- This feature request is to disallow such query to run when the estimate tempdb space is larger than the size of tempdb during optimization.
SAP Adaptive Server Enterprise (ASE) 16.0
SAP Adaptive Server Enterprise 15.7
KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Product Enhancement
About this pageThis is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).
Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.