SAP Knowledge Base Article - Preview

2950419 - Why is the "Found in Wash" percentage so high on a named log cache?

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

SAP Adaptive Server Enterprise 16.0

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.