Symptom
Everything looks good, but the caches are not being used when replaying a workload:
sp_helpcache
go
Cache Name Config Size Run Size Overhead Cache Type
--------------------------- ------------- ---------- ---------- ------------
mydb_Cache 28000.0 Mb 28000.0 Mb 2261.58 Mb Mixed
mydb_LogCache 500.00 Mb 500.00 Mb 40.13 Mb Log Only
...
------------------ Cache Binding Information: ------------------
Cache Name Entity Name Type Index Name Status
---------- ----------- ---- ---------- ------
mydb_Cache mydb database V
mydb_LogCache mydb.dbo.syslogs table V
...
sp_helpcache mydb_Cache
go
Cache Name Config Size Run Size Overhead Cache Type
---------------- ------------- ---------- ---------- ------------
mydb_Cache 28000.0 Mb 28000.0 Mb 2261.58 Mb Mixed
Memory Available For Memory Configured
Named Caches To Named Caches
-------------------- ----------------
97759.9 Mb 28000.0 Mb
------------------ Cache Binding Information: ------------------
Cache Name Entity Name Type Index Name Status
---------- ----------- ---- ---------- ------
mydb_Cache mydb database V
mydb_LogCache mydb.dbo.syslogs table V
Read more...
Environment
SAP Adaptive Server Enterprise (ASE) 16.0
Product
SAP Adaptive Server Enterprise 16.0
Keywords
WLA Work Load Analyzer , 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.