Post reply

I can't see "cache hit ratio" counter

  • January 24, 2008 at 9:45 pm

    #127641

    In perfmon I can't see anymore any SQL Server - related counter, not only the above-mentioned one. What is going on?????

  • January 25, 2008 at 6:06 am

    #771695

    Is the SQL Service on that machine running?

    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

  • January 25, 2008 at 8:33 am

    #771791

    Ofcourse it is .. otherwise I would be fired ... 🙂

  • January 25, 2008 at 11:45 am

    #771952

    Try to reload the counters:

    lodctr \\servername "c:\Program Files\Microsoft SQL Server\MSSQL\Binn\sqlctr.ini"

    Also, make sure you have SP4 applied, it has this fix:

    http://support.microsoft.com/kb/812915/en-us

  • January 25, 2008 at 2:00 pm

    #772017

    virgilash (1/25/2008)

    Ofcourse it is .. otherwise I would be fired ... 🙂

    Had to ask. You'll be amazed how often the simplest possible explanation to a problem is the correct one. Occam's Razor.

    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

Viewing 5 posts - 1 through 4 (of 4 total)

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