Post reply

no SQL Server performance counters

  • May 11, 2010 at 9:23 am

    #386906

    Hi all,

    Apologies if this is a dumb question.

    I'm trying to run some performace monitoring on a SQL server and I don't have any of the SQL server counters in the object list.

    Do I need to enable something somewhere?

    Thanks.

  • May 11, 2010 at 1:29 pm

    #1165794

    http://www.sqlcoffee.com/Tuning02.htm

  • May 13, 2010 at 2:40 am

    #1166704

    Thanks for this, but when I ran the command it said SQL counters were already installed.

    They just don't appear in the Performance Object dropdown.

  • May 14, 2010 at 8:57 am

    #1167602

    Check this key:

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

    I had this problem recently and it was set to 1. After I changed it, I was able to load them using the directions given in the earlier posted link.

    Reloading the SQL Server Counters

    (a) In command line, locate the current folder to C:\Program Files\Microsoft SQL Server\MSSQL\BINN

    (b) Execute "lodctr sqlctr.ini"

    Then reboot.

  • May 14, 2010 at 9:05 am

    #1167612

    Hmm, I didn't have that item at all.

    I have added it and set the value to 0 - I'll reboot the server over the weekend and see what happens.

  • May 18, 2010 at 1:56 am

    #1168624

    Which version od SQL Server?

    I had a 32-bit SQL instance on 64-bit windows, and could not see the performance counters.

    Until I ran \WINDOWS\SysWOW64\perfmon.exe - all counters appeared...

  • May 18, 2010 at 2:07 am

    #1168627

    Sir, you are a genius!

    I did have 32bit SQL on a 64 bit server and running perfmon.exe brings up the counters.

    Now I just need to find out why my tempdb is going through the roof!! 🙂

  • May 18, 2010 at 2:27 am

    #1168647

    Glad to help - this took me a long time to fix.:-)

Viewing 8 posts - 1 through 7 (of 7 total)

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