Home Forums SQL Server 2008 SQL Server 2008 - General Buffer catch Hit ration RE: Buffer catch Hit ration

  • August 27, 2012 at 1:05 am

    #1530204

    That the alert is set up in error, buffer cache hit ratio of 100 is good, not bad.

    Double-check what the alert was actually complaining about. It is was buffer cache hit ratio, you can ignore it.

    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