Results 1 to 12 of 12
  1. #1
    Join Date
    Oct 2003
    Posts
    268

    Unanswered: No SQL Server Performance Monitor Counters

    On some of my database servers, there are SQL Server counters in Performance Monitor. On other servers these are not present. How can I turn these on?

    I know with the disc counters you need to explicitly enable them:
    diskperf -yv

    Is there a parallel for SQL Server? I don't remember doing anything to get them working on the servers that have them. All online articles seem to assume that they just exist.

    TIA!

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    I've run across this problem before, but the only solution that I found was KB#300956, or the somewhat simpler but more drastic step of reinstalling SQL Server and reapplying the services packs to it.

    -PatP

  3. #3
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    Check this key:

    HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Servic es\Tcpip\Performance\Disable Performance Counters

    It should be 0.
    "The data in a record depends on the Key to the record, the Whole Key, and
    nothing but the Key, so help me Codd."

  4. #4
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    Scratch the previous post.

    Do the following at the DOS prompt:

    unlodctr.exe MSSQLServer
    lodctr.exe <SQL Server path>\binn\sqlctr.ini
    "The data in a record depends on the Key to the record, the Whole Key, and
    nothing but the Key, so help me Codd."

  5. #5
    Join Date
    Jul 2004
    Posts
    60
    another option:

    select * from master..sysperfinfo

    ...i'd be curious as to whether that table was there even with the counters missing...

  6. #6
    Join Date
    Oct 2003
    Posts
    268
    Quote Originally Posted by rdjabarov
    Check this key:

    HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Servic es\Tcpip\Performance\Disable Performance Counters

    It should be 0.
    It didn't exist. I created it and set it to 0 and restarted the system and it had no effect.

  7. #7
    Join Date
    Oct 2003
    Posts
    268
    Quote Originally Posted by rdjabarov
    unlodctr.exe MSSQLServer
    lodctr.exe <SQL Server path>\binn\sqlctr.ini
    Tried this and rebooted and it still doesn't work.

    I reinstalled SQL Server 2000 Enterprise Edition w/SP3a not too long ago. That looks like my last option.

    Thanks for the feedback guys

  8. #8
    Join Date
    Oct 2003
    Posts
    268
    Quote Originally Posted by oddity
    select * from master..sysperfinfo

    ...i'd be curious as to whether that table was there even with the counters missing...
    I got a blank result set back. That means the table is there. Does that tell me anything?

  9. #9
    Join Date
    Jul 2004
    Posts
    60
    prolly not...
    i was wondering if that table continued to track the counter data even if perfmon mysteriously 'dropped' the counters, which i have seen before and have not yet explained to myself. that table is where perfmon gets its SQL counter data from. thanks!

  10. #10
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    Did you check availability of SNMP?
    "The data in a record depends on the Key to the record, the Whole Key, and
    nothing but the Key, so help me Codd."

  11. #11
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    Maybe this will shed some light on the problem...
    "The data in a record depends on the Key to the record, the Whole Key, and
    nothing but the Key, so help me Codd."

  12. #12
    Join Date
    Jul 2004
    Posts
    60
    a bright shiny light.
    still no idea where they go and why, but getting them back is no longer a mystery.
    thanks!

Posting Permissions

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