Monday, 11 January 2010

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, this can be found 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.

3 comments:

  1. Nice post. I think you are referring to http://sqlblogcasts.com/blogs/tonyrogerson/archive/2006/12/02/missing-perfmon-counters-using-64-bit-windows-mmc-32-perfmon-msc.aspx

    Like your posts a lot. Keep going..
    Manu

    ReplyDelete
  2. Manu, thanks for the link, I have updated the post with it.

    I'm glad that you like my posts ad thank you for the words of encouragement.

    ReplyDelete
  3. Hey Manu, thanks a lot....

    ReplyDelete

Featured post

SQL Server 2008 and SQL Server 2008 R2 - OUT of SUPPORT July 2019

Both SQL Server 2008 and SQL Server 2008 R2 go out of extended support with Microsoft in July 2019. That’s fast approaching and as we enter ...