Issues with performance counter

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Administering » Issues with performance counter

Issues with performance counter

Rate Topic

Display Mode

Topic Options

Author

Message

rafa.aborges

Posted Friday, December 04, 2009 5:53 AM

SSC Rookie

Group: General Forum Members
Last Login: 2 days ago @ 10:48 AM
Points: 40, Visits: 211

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

Post #828790

joeroshan

Posted Friday, December 04, 2009 6:00 AM

Mr or Mrs. 500

Group: General Forum Members
Last Login: 2 days ago @ 3:45 AM
Points: 572, Visits: 1,157

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
Custom cleanup script for backups

Post #828797

rafa.aborges

Posted Friday, December 04, 2009 6:56 AM

SSC Rookie

Group: General Forum Members
Last Login: 2 days ago @ 10:48 AM
Points: 40, Visits: 211

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?

Post #828859

rafa.aborges

Posted Tuesday, December 22, 2009 9:42 AM

SSC Rookie

Group: General Forum Members
Last Login: 2 days ago @ 10:48 AM
Points: 40, Visits: 211

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

Post #838018

rafa.aborges

Posted Monday, December 28, 2009 8:17 AM

SSC Rookie

Group: General Forum Members
Last Login: 2 days ago @ 10:48 AM
Points: 40, Visits: 211

Anyone?

Post #839428

BudaCli

Posted Wednesday, February 10, 2010 4:06 AM

Ten Centuries

Group: General Forum Members
Last Login: Wednesday, March 27, 2013 9:02 AM
Points: 1,046, Visits: 573

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

Post #863073

« Prev Topic | Next Topic »

Permissions