SAP Knowledge Base Article - Preview

3159884 - Created caches and bound them to the objects, but the caches are not being used - SAP ASE

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.