Results 1 to 14 of 14

Thread: Missing counters in Performance Monitor

  1. #1
    Join Date
    Oct 2002
    Posts
    92

    Missing counters in Performance Monitor

    Im missing all SQL Server counters in the Performance Monitor

    and have looked at article: http://support.microsoft.com/default...NoWebContent=1

    but this article refers to SQL 7...I have 2K with SP3 and MS03-031

    How can I get my counters ? thanks

  2. #2
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    Follow the instruction in the article to add counters. The .ini file is located in

    C:\Program Files\Microsoft SQL Server\MSSQL\Binn

  3. #3
    Join Date
    Oct 2002
    Posts
    92
    I found 2 filesne is called "sqlctr.ini" and the other is called "sqlctr.h"...should I just delete the sqlctr.h file ?
    and why would it have an extension of "h" ?
    Last edited by kim; 08-20-2003 at 03:25 PM.

  4. #4
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    Use SQLCTR.INI with loadctr.

  5. #5
    Join Date
    Sep 2002
    Location
    Fantasy
    Posts
    4,254
    .h files are C or C++ header files.

    This file has all constants.

    If you open the file you can see the following lines

    // This file is generated by the description file processor.
    // Please do not edit.

  6. #6
    Join Date
    Oct 2002
    Posts
    92
    isql ?
    Last edited by kim; 08-21-2003 at 12:13 PM.

  7. #7
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    Start - Run - Cmd

  8. #8
    Join Date
    Oct 2002
    Posts
    92
    I opened the cmd window and changed the directory to where the sqlctr.ini resides (D:\Program Files\Microsoft SQL Server\MSSQL\Binn)

    then ran "unlodctr mssqlserver"
    then ran "lodctr D:\Program Files\Microsoft SQL Server\MSSQL\Binn\sqlctr.ini"

    then opened and closed performance monitor...but still cant find my counters ?...any other ideas ?...do I need to stop and start SQL Server ?

    thank you

  9. #9
    Join Date
    Oct 2002
    Posts
    92
    In addition I found this msg in the sql server log:
    "performance monitor shared memory setup failed: -1"

    any idea if this is related ?

  10. #10
    Join Date
    Sep 2002
    Posts
    5,938
    Yes, have to restart sql service.

  11. #11
    Join Date
    Oct 2002
    Posts
    92
    the counters are still not showing up

  12. #12
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    Did you reboot the server or just restarted SQL Server?


    Check if the counters are listed in registry

    http://support.microsoft.com/default...;en-us;q127207

  13. #13
    Join Date
    Oct 2002
    Posts
    92
    thank you, but that article applies to NT...whereas I have Windows 2K server

  14. #14
    Join Date
    Sep 2002
    Posts
    5,938
    Should work as well.

Posting Permissions

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