SQL Server Performance

Perfmon counter Cache manager Execution Context

Discussion in 'SQL Server 2005 Performance Tuning for DBAs' started by pwijn, Mar 29, 2007.

  1. pwijn New Member


    Hello,

    as I have understand it is a best practice to monitor SQL Performance counters.
    Cache Hit Ration should have a value near to 99%. When I monitor this value for a 800Gb database over here (200 users) it remains at a value of 68.9%.
    When I zoom the drop from 100% seems to be related to the Cache Managers value for Execution Contexts which is at 36,6%.
    What might be causing this and how to solve it?

    Perfmon shows:


    SQLServer:Cachemanager _Total Cursors Execution Contexts Misc. Normalized Trees Prepared Plans
    -Cache Hit Ratio 68,924 99,958 36,663 90,357 99,978
    -Cache object Counts 26513 1405 8825 3 13981

    Thanks!
  2. Luis Martin Moderator

    May be you are confused with Buffer Cache Hit Ratio. This one should be near 99%.
    In my clients I never see Cache Hit Ratio more than 70%.

    Luis Martin
    Moderator
    SQL-Server-Performance.com

    All in Love is Fair
    Stevie Wonder


    All postings are provided “AS IS” with no warranties for accuracy.



  3. pwijn New Member

    Oops..... you are so right!

    I think the topic can be dropped [:I]

    thanx!

Share This Page