Does this syntax still apply for a 64 bit OS & SQL server?
Win32_PerfFormattedData_MSSQLNAMED_SQLNAMEDServerBufferManager
Hello Jeff,you can easily check this by running "wbemtest" command on target system. "Windows management instrumentation tester" window appears, there click "Connect", set "Namespace" to "root\cimv2" and click "Connect" again. Then click "Enum Classes ...", leave "Enter superclass name" empty, select "Recursive" and click "OK". List of all classes in the system appears and you can check if required class it there or not.
This is the closet I have found yet to answering my issue. And I have opened a ticket so I hope it gets solved.
I am trying to monitor SQL 2008 R2 32bit that is running on Server 2003 R2 x64. The 32bit counters are visible and working on the 64 bit system if I use PerfMon /32 to view the 32bit counters from the 64 bit server.
But when I use wbemtest that you suggest. It is only showing me the 64bit counters that I can see using the 64bit Perfmon util. If I can figure out how to see the 32bit counter using wbemtest, I should be able to use that info to make a copy of the APM SQL 2005-2008 template work for my two 64bit servers running 32bit SQL. As it works fine to monitor my 32bit SQL on 32bit servers.
Any ideas?
blogs.msdn.com/.../troubleshooting-sql-server-2005-2008-performance-counter-collection-problems.aspx
"WOW Support: Collection of 32 bit SQL Server counters is not supported from WMI on 64 bit operating system"
This is an MSDN blog, so I believe this is a true statement. Is this why the template named SQL Server 2005-2008 Performance (WMI) is not working for me?
Ticket closed. Solarwind confirmed this MSDN comment is why it doesn't work for me.
