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.
SAP Knowledge Base Article - Preview