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
sp_sysmon, log cache, found in wash , 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