Issues with performance counter

  • 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

  • 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]

  • 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?

  • 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

  • Anyone?

  • 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