SQL Server Performance

Missing Counters

Discussion in 'General DBA Questions' started by Luis Martin, Dec 14, 2004.

  1. Luis Martin Moderator

    I was reading all about that in Microsoft, but I have not cluster, w3k, etc.

    Configuration: W2k sp4, SQL 2k sp3a.
    When I run Performance Monitor I find numbers instead sql counters. All others counter works fine, but for some reason I miss all sql counters.

    Any clue?


    Edited, just to refresh today.


    Luis Martin
    Moderator
    SQL-Server-Performance.com

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

  2. satya Moderator

    Have you tried to unload and load the counters using LODCTR utility.

    Satya SKJ
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
  3. Luis Martin Moderator

    No. I'll try next week and back to report results.
    Thanks.



    Luis Martin
    Moderator
    SQL-Server-Performance.com

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

  4. thomas New Member

    I need to try this myself on Monday.. on my main live OLTP server... I'll let you know how I get on, Luis.


    Tom Pullen
    DBA, Oxfam GB
  5. EsioN New Member

    I have this problem when I change "Reserve physical memory" from Enterprise Managers (I'm using dynamically memory allocation), its ask me about restart the service, if I answer Yes the service is restarted but the sql counters disappear. When I restart (shutdown) the server, the counter appear again...
    The same occurs if I use sp_configure 'set working set size', after I restart the service, the counters are missing; when I restart the server, it's OK...


    Ésio Nunes


    Esio Nunes
  6. Luis Martin Moderator

    LODCTR, is for Analysis Service Counters. I miss regular SQL counters and I only have numbers. Windows counters are Ok.


    Any clue?

    Luis Martin
    Moderator
    SQL-Server-Performance.com

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

  7. satya Moderator

    Esio

    What is the operating system and the service pack applied?

    Satya SKJ
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
  8. Luis Martin Moderator

    W2k SP4, SQL2k SP3a

    Luis Martin
    Moderator
    SQL-Server-Performance.com

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

  9. thomas New Member

    Luis, do you know how to do this yet?

    I did it yesterday.

    simply run (at command prompt)

    unlodctr

    then run

    lodctr "C:program filesmicrosoft sql serverinnsqlctr.ini"

    and reboot

    Amend the path to you installed SQL Server programs binn folder if necessary.

    This worked fine for me.



    Tom Pullen
    DBA, Oxfam GB
  10. Luis Martin Moderator

    I'll try and back with results.

    Thanks.


    Luis Martin
    Moderator
    SQL-Server-Performance.com

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

  11. Luis Martin Moderator

    Does not work, but I find a Microsoft Fix to resolve the problem.

    Thanks again,


    Luis Martin
    Moderator
    SQL-Server-Performance.com

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

  12. satya Moderator

    It will be nice to hear the solution and will be a reference if similar issue occurs for others.

    Satya SKJ
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
  13. Luis Martin Moderator

    Yes, I forget.

    When sysperfinfo is empty and you have in SQL log the following error:

    Performance monitor shared memory setup failed: -1

    Then the solution is:

    http://support.microsoft.com/default.aspx?scid=kb;en-us;812915&Product=sql2k


    In my case I'll wait for next sp.



    Luis Martin
    Moderator
    SQL-Server-Performance.com

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

  14. bj007 New Member

    Louis,

    Did you apply this hotfix ? Did this solve your problem ?

    How do I uninstall this, if it doesnt work ?

    bijo
  15. satya Moderator

    In order to work the process you must apply the hotfix as per the KBA referred.

    TO backout refer to the list of files referred, take a backup before applying and replace if you want to backout the hotfix by stopping sQL Server services.

    Satya SKJ
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
  16. Luis Martin Moderator

    I did not apply the hotfix, because Microsoft recommend (if you can wait) to SP4.



    Luis Martin
    Moderator
    SQL-Server-Performance.com

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

  17. satya Moderator

    But if you need immediate results I suggest to test and apply, SP4 is still in beta stages.

    Satya SKJ
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
  18. hawksr New Member

    Ok, sorry to bring this up again, but I'm still experince this issue after i've upgraded to sp4. I've looked on KB and all references say that it should be fixed with SP4. Is anyone else still exeperice this after the upgrade?

    sean
  19. satya Moderator

    How about the hotfix post SP4?

    Satya SKJ
    Microsoft SQL Server MVP
    Contributing Editor & Forums Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
  20. hawksr New Member

    I'm running .2159 which is a higher version then the inital SP4. We had to apply a hotfix due to a seperate issue invovling blocking while running dbcc indexdefrag. I was assume that since the original KB stated that the hotfix was for SP3(a) that the problem was resolved with SP4. This doesn't seem to be the case. Any thoughts/suggestions?

    sean
  21. hawksr New Member

    Curiously i DO NOT receive the "Performance monitor shared memory setup failed: -1" error message. I just don't get the SQL SERVER counters in the perfmon. I've tried the unlodctr and lodctr, but that didn't seem help either.

    sean

Share This Page