InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comMon, 20 May 2013 06:39:49 GMT20http://www.sqlservercentral.com/Forums/Topic828790-146-1.aspxThanks 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)?Wed, 10 Feb 2010 04:06:48 GMTBudaClihttp://www.sqlservercentral.com/Forums/Topic828790-146-1.aspxAnyone?Mon, 28 Dec 2009 08:17:46 GMTrafa.aborgeshttp://www.sqlservercentral.com/Forums/Topic828790-146-1.aspxIs 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: 0x80041010Facility: WMIDescription: Invalid classAny ideas?ThanksTue, 22 Dec 2009 09:42:53 GMTrafa.aborgeshttp://www.sqlservercentral.com/Forums/Topic828790-146-1.aspxGreat, 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: 0x80041010Facility: WMIDescription: Invalid classAny idea?Fri, 04 Dec 2009 06:56:46 GMTrafa.aborgeshttp://www.sqlservercentral.com/Forums/Topic828790-146-1.aspxPlease look at the link.[url]http://sqlblogcasts.com/blogs/tonyrogerson/archive/2006/12/02/missing-perfmon-counters-using-64-bit-windows-mmc-32-perfmon-msc.aspx[/url]Fri, 04 Dec 2009 06:00:57 GMTjoeroshanhttp://www.sqlservercentral.com/Forums/Topic828790-146-1.aspxHi 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?ThanksFri, 04 Dec 2009 05:53:14 GMTrafa.aborges