Results 1 to 4 of 4
  1. #1
    Join Date
    Jan 2004
    Posts
    32

    Unanswered: High Cache Hits / High Pool Turnover

    How can be the cache hits is high (100%) when there is lot of pool turnover? (Bellow is the section of sysmon). Can any one give some information in understanding the relation here?

    -------------------------------------------------------------------------------
    Cache: default data cache
    per sec per xact count % of total
    ------------------------- ------------ ------------ ---------- ----------
    Spinlock Contention n/a n/a n/a 0.0 %

    Utilization n/a n/a n/a 53.8 %

    Cache Searches
    Cache Hits 36304.2 68.9 21782536 100.0 %
    Found in Wash 1710.8 3.2 1026485 4.7 %
    Cache Misses 4.1 0.0 2434 0.0 %
    ------------------------- ------------ ------------ ----------
    Total Cache Searches 36308.3 68.9 21784970

    Pool Turnover
    2 Kb Pool
    LRU Buffer Grab 14.2 0.0 8520 50.0 %
    Grabbed Dirty 0.0 0.0 0 0.0 %
    4 Kb Pool
    LRU Buffer Grab 14.0 0.0 8398 49.2 %
    Grabbed Dirty 0.0 0.0 0 0.0 %
    16 Kb Pool
    LRU Buffer Grab 0.0 0.0 16 0.1 %
    Grabbed Dirty 0.0 0.0 0 0.0 %
    ------------------------- ------------ ------------ ----------
    Total Cache Turnover 28.4 0.1 17054

  2. #2
    Join Date
    Jan 2004
    Posts
    32

    sp_sysmon (High Cache Hits / High Pool Turnover)??

    How can be the cache hits is high (100%) when there is lot of pool turnover? (Bellow is the section of sysmon). Can any one give some information in understanding the relation here?

    -------------------------------------------------------------------------------
    Cache: default data cache
    per sec per xact count % of total
    ------------------------- ------------ ------------ ---------- ----------
    Spinlock Contention n/a n/a n/a 0.0 %

    Utilization n/a n/a n/a 53.8 %

    Cache Searches
    Cache Hits 36304.2 68.9 21782536 100.0 %
    Found in Wash 1710.8 3.2 1026485 4.7 %
    Cache Misses 4.1 0.0 2434 0.0 %
    ------------------------- ------------ ------------ ----------
    Total Cache Searches 36308.3 68.9 21784970

    Pool Turnover
    2 Kb Pool
    LRU Buffer Grab 14.2 0.0 8520 50.0 %
    Grabbed Dirty 0.0 0.0 0 0.0 %
    4 Kb Pool
    LRU Buffer Grab 14.0 0.0 8398 49.2 %
    Grabbed Dirty 0.0 0.0 0 0.0 %
    16 Kb Pool
    LRU Buffer Grab 0.0 0.0 16 0.1 %
    Grabbed Dirty 0.0 0.0 0 0.0 %
    ------------------------- ------------ ------------ ----------
    Total Cache Turnover 28.4 0.1 17054

  3. #3
    Join Date
    Jun 2003
    Posts
    140
    I dont think there is any relation bwt the two.

    -> cache hits indicates the no of times that a needed page was found in
    the data cache. -- which is fine in your case

    -> Pool Turnover indicates the number of times that a buffer is replaced from
    each pool in a cache.- which is high in your case

    did u use relaxed LRU replacement policy in this cache

  4. #4
    Join Date
    Jan 2004
    Posts
    32
    no i did not use relaxed LRU replacement policy.

    As you said:
    "-> Pool Turnover indicates the number of times that a buffer is replaced from each pool in a cache.- which is high in your case"

    If pool turnover is high, how come the cache hit is 100%?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •