Perf_Counter Problem 32bit and 64bit MSSQL Instance

[Brujah]

(Sorry For my English)
I have a Problem with the perf_counter.

I have Mssql 2008 installed with 32bit Instance and 64bit instance on a Windows 2008 r2 64bit.

So I use perf_counter["\MSSQL$Instance64bit:General Statistics\User Connections"] and that work Perfectly.

But if I try to use perf_counter["\MSSQL$Instance32bit:General Statistics\User Connections"] that doesn't work.

I try to found the good information in the Performance Monitor tools and no Counter was available for all my 32bit instance. So i try google.

after some search on google about the problem. I found this

http://sqlblogcasts.com/blogs/tonyrogerson/archive/2006/12/02/missing-perfmon-counters-using-64-bit-windows-mmc-32-perfmon-msc.aspx

So if a use mmc /32 perfmon.msc i can found all the Counter i want 32 and 64bit but that doesn't fix the problem on zabbix.

Someone have fix this problem.

[tchjts1]

It is possible that different servers have unique performance counters.

The best way to get the performance counter you are looking for is to bring up a DOS command box and type:

[B]typeperf -qx > perfcounter.txt[/B]

Then use an editor (I like Notepad++) on the txt file you just created to find the perf counter syntax you are looking for.

[Brujah]

I did what you say, and i Only see the MSSQL 64bit instance on that files.


So the MSSQL 32bit instance not available.

[tchjts1]

I did what you say, and i Only see the MSSQL 64bit instance on that files.


So the MSSQL 32bit instance not available.

Correct. I don't think you would have both versions of MSSql running at the same time.

Typeperf (And Perfmon) only pick up what is running on the machine at the time you launch them.

[Brujah]

You can Have MSSQL installed on the same server in 32 and 64bit.

Like i say Before. If i run MMC /32 perfmon.msc I can Found all my instance in 32 and 64bit.

if you look at attachment you will see i run Two Process of sqlserver.exe one 64bit and the Other one with *32 are 32 bit.


So if i read again that post from microsoft http://support.microsoft.com/kb/891238/en-us we have to install zabbixclient in 32bit.

So the Question, If i install ZabbixClient64 i know i have only access to see 64 bit Perfmance Counter, but if i install zabbixclient 32bit should i see both 32 and 64 bit Performance Counter.

[Brujah]

I can Confirme after doing some test, If you Install ZabbixClient 32bit All performance Coutner WORK.

[tchjts1]

I can Confirme after doing some test, If you Install ZabbixClient 32bit All performance Coutner WORK.

That's very interesting, and not what I would have expected.

In the past, we have installed the incorrrect version of Zabbix on Windows servers by accident (32bit on a 64bit system) and have had issues gathering even basic metrics such as CPU and memory usage.

I'm glad it worked out for you though.