Post reply

Buffer cache hit ratio low?

  • April 14, 2009 at 12:42 pm

    #199452

    One of our database instances has a buffer cache hit ratio that dips below 90% for 10 minute periods. What can be the cause of this? It's sql 2005 SP2, small user db (~ 200mb), 3GB ram. Should I be concerned? Thanks,

  • April 14, 2009 at 12:54 pm

    #977549

    It's very hard to say what causes a dip in cache hit ratio. In fact it's difficult to work out when sitting in front of the server with full access to it.

    If it happens regularly, is there something that runs at those times? SQL Job? Scheduled windows task?

    May I suggest profiler/SQL Trace to see what's happening and correlate it back to the dip in cache hit ratio?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • September 3, 2010 at 9:05 am

    #1216219

    Hi Gail,

    I have my buffer cache hit ratio very low ....wat are the step by step solution for this...if you could help me on this tht would be grt!!!!!!!!!!!!

    aashu

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply