Symptom
The sp_sysmon shows:
-----------------------------------------------------------------------------
Cache: MY_LogCache
per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Spinlock Contention n/a n/a n/a 0.1 %
Utilization n/a n/a n/a 0.0 %
Cache Searches
Cache Hits 3.8 0.0 1141 100.0 %
Found in Wash 27.7 0.0 8308 728.1 %
Cache Misses 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ----------
Total Cache Searches 3.8 0.0 1141 Pool Turnover
4 Kb Pool
LRU Buffer Grab 0.2 0.0 65 0.8 %
Grabbed Locked Buffer 0.0 0.0 0 0.0 %
Grabbed Dirty 0.0 0.0 0 0.0 %
8 Kb Pool
LRU Buffer Grab 27.6 0.0 8278 99.2 %
Grabbed Locked Buffer 0.0 0.0 0 0.0 %
Grabbed Dirty 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ----------
Total Cache Turnover 27.8 0.0 8343
Read more...
Environment
SAP Adaptive Server Enterprise 16.0
Product
Keywords
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.