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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.