Post reply

Issues with performance counter

  • December 4, 2009 at 5:53 am

    #156471

    Hi guys,

    I'm having an issue with performance counters for MSSQL.

    The problem is that the counter are missing on perfmon.

    I tried to unlodctr and lodctr again, but it didn't work. I also tried to run wmiadap /p and wmiadap /resyncperf and restart the WMI service with no results.

    I think that the problem is because we're running on a Windows Server 2003 64 bits with SQL Server 2005 32 bits.

    Anyone have an idea what I could do to solve this problem?

    Thanks

  • December 4, 2009 at 6:00 am

    #1087615

    Please look at the link.

    http://sqlblogcasts.com/blogs/tonyrogerson/archive/2006/12/02/missing-perfmon-counters-using-64-bit-windows-mmc-32-perfmon-msc.aspx

    ----------------------------------------------------------------------------------------------------------------------------------------------------
    Roshan Joe

    Jeff Moden -Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • December 4, 2009 at 6:56 am

    #1087670

    Great, thanks! It worked!

    The problem now is when I run the wbemtest and execute anything on the query (ex: "select * FROM win32_perfrawdata_mssqlserver_sqlserverbuffermanager"), shows the following error:

    Number: 0x80041010

    Facility: WMI

    Description: Invalid class

    Any idea?

  • December 22, 2009 at 9:42 am

    #1095479

    Is there any way to add win32_perfrawdata_mssqlserver_* classes into the WMI repository?

    When I try to run a query using the win32_perfrawdata_mssqlserver* classes on WBEMTEST under the root\cimv2 I got the following error:

    Number: 0x80041010

    Facility: WMI

    Description: Invalid class

    Any ideas?

    Thanks

  • December 28, 2009 at 8:17 am

    #1096686

    Anyone?

  • February 10, 2010 at 4:06 am

    #1116674

    Thanks for an update but what if I have 2 instances on 1 machine, one SQL 2k5 which is not being used and it is a named instance and the other being SQL 2k8 as a default instance and also running.

    When wanting to add perf counters for SQL it shows the SQL counters for a named instance but not for SQL 2k8, is there a way to view counters for SQL 2k8(default instance)?

    What you don't know won't hurt you but what you know will make you plan to know better

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

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