December 4, 2009 at 5:53 am
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
Please look at the link.
December 4, 2009 at 6:56 am
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
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
Anyone?
February 10, 2010 at 4:06 am
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)?
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply