Perfmon Bad data error

[Rhys]

I get the following error on one of our server...

Perfmon data is missing objects: SQLServer:Access Methods, SQLServer:Buffer Manager, SQLServer:Databases, SQLServer:General Statistics, SQLServer:Latches, SQLServer:Locks, SQLServer:Memory Manager, SQLServer:SQL Statistics. Possible causes include performance counter library corruption, or a 32-bit/64-bit mismatch between Windows and the performance counter provider (e.g. SQL Server).

I've executed the Powershell command

Get-Counter -ComputerName server -ListSet "*sql*"

and I only get the ".Net Data Provider for SqlServer" listed. On other servers I get many more sql related counters. Anyone know what might be the issue here?

[priyasinha]

Hi Rhys,

This error generally comes up when performance monitor doesn't return the data for the counters.

Could you please try the following?

1. Is the problematic SQL Server a 32 bit SQL Server on 64 bit windows OS? If no, then please try step 2.
2. Open Performance/ System monitor (open Run and then type perfmon). Then select the listed performance counters i.e. SQLServer:Access Methods, SQLServer:Buffer Manager etc and verify if you can see values for this counters in Performance monitor. If you are not able to see any values here then there is a chance that the performance library might be corrupt and you may have to rebuild it. Please try the steps as listed in support article from Microsoft. The link to article is listed in this help page.

http://www.red-gate.com/supportcenter/Content.aspx?c=SQL_Monitor/help/2.0/SM_Adding_Servers.htm&p=SQL%20Monitor

Thanks,
Priya

[Rhys]

Hi Priya

Yes, it's 32 bit SQL on 64 bit OS. Is this unsupported? Must have missed this.

Rhys

[priyasinha]

Hi Rhys,

Unfortunately this is a Microsoft issue and we cannot do anything about it.

http://support.microsoft.com/kb/891238

http://blogs.technet.com/b/rob/archive/2010/05/31/sql-server-wow64-perfmon-issues.aspx

Thanks,
Priya

[Baguck]

*Sorry for digging up an old thread, I just found this by searching for my issue.*

Is there any update to this issue?

I understand that this is a Windows issue, I just did not know if a workaround had been discovered similar to the /32 workaround for perfmon.

This 64bit/32bit setup describes 95% of the servers that I administer. There are plans for the setup to be updated in the near future, but wondering if there is a workaround for the present.

Thanks

[priyasinha]

[Lynchie435]

I have the same error:

22 May 2013 1:14 PM General Perfmon Bad data #Rnv

Perfmon data is missing objects: SQLServer:Access Methods, SQLServer:Buffer Manager, SQLServer:Databases, SQLServer:General Statistics, SQLServer:Latches, SQLServer:Locks, SQLServer:Memory Manager, SQLServer:SQL Statistics. Possible causes include performance counter library corruption, or a 32-bit/64-bit mismatch between Windows and the performance counter provider (e.g. SQL Server).

We are running 64bit 2008 Datacentre and 64 bit SQL Server 2008 RS. When checking perfmon on the machine itself the counters are all there.

If I run Powershell Command: