Symptom
sp_cacheconfig "default data cache", "1024M"
This increased the size of the default data cache from 4MB to 512MB – no errors.
sp_helpcache showed:
Cache Name Config Size Run Size Overhead
------------------ ------------- ---------- ----------
default data cache 512.00 Mb 512.00 Mb 164.19 Mb
Tried the same command again:
sp_cacheconfig "default data cache", "1024M"
and from sp_helpcache
Cache Name Config Size Run Size Overhead
------------------ ------------- ---------- ----------
default data cache 512.00 Mb 512.00 Mb 164.19 Mb
Then when I rebooted the ASE server and ran
sp_helpcache:
Cache Name Config Size Run Size Overhead
------------------ ------------- ---------- ----------
default data cache 512.00 Mb 512.00 Mb 164.19 Mb
The same results happen, even when more memory is added to the server.
No errors just wrong results.
Read more...
Environment
SAP Adaptive Server Enterprise 16.0
Product
Keywords
KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Problem
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.