Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Permon Counters Missing Windows 64 Bit SQL Server 32 Bit

For reasons beyond the scope of this post I have an environment where I have Windows 2003 R2 64 bit running but SQL Server 2005 running on 32 bit.


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.

Comments

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.

Leave a Comment

Please register or log in to leave a comment.