Subscribe to this blog
Briefcase
Print
Having fired up perfmon I could not see the SQL Server 2005 counters which left me in a state of confusion. Having had a quick google I found a very good post from Tony Rogerson, when I find the link again I will post it here.
I had fired up the 64 bit version of perfmon so the 32-bit counters for SQL Server do not appear. To get around this you need to open the 32 bit version of Perfmon which you can do by running the following:
mmc /32 perfmon.msc
Having fired up this version of PerfMon all the SQL counters were available to me including the named instance counters listed under the name of the instance.
Posted by bvk_d on 8 April 2010
The same environement i have and i got the counters in perfmon /32 and added to the log but sql server counters data is not captured in log.But system counters are capturing what is the problem can you any body help me out.