Perfmon Bad data error

SQL Server performance monitoring and alerting

Moderators: eddie davis, priyasinha, Adam, chriskelly, Chris Lambrou, Chris Spencer

Perfmon Bad data error

Postby Rhys » Wed Dec 01, 2010 1:26 pm

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?
Rhys
 
Posts: 21
Joined: Wed Dec 01, 2010 1:20 pm

Postby priyasinha » Wed Dec 01, 2010 2:37 pm

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/C ... %20Monitor

Thanks,
Priya
priyasinha
 
Posts: 532
Joined: Wed Jan 03, 2007 5:02 pm

Postby Rhys » Wed Dec 01, 2010 4:42 pm

Hi Priya

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

Rhys
Rhys
 
Posts: 21
Joined: Wed Dec 01, 2010 1:20 pm

Postby priyasinha » Wed Dec 01, 2010 5:15 pm

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/ ... ssues.aspx

Thanks,
Priya
priyasinha
 
Posts: 532
Joined: Wed Jan 03, 2007 5:02 pm

Postby Baguck » Thu Jul 26, 2012 7:51 pm

*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
Baguck
 
Posts: 4
Joined: Thu Jul 26, 2012 7:47 pm
Location: USA - North Carolina

Re:

Postby priyasinha » Fri Jul 27, 2012 9:16 am

Baguck wrote:*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


Hi,

Thanks for your post. Unfortunately, there is no workaround for the this windows limitations.

Regards,
Priya
priyasinha
 
Posts: 532
Joined: Wed Jan 03, 2007 5:02 pm

Sorry for also bringing this up but I have a similar issue.

Postby Lynchie435 » Wed May 22, 2013 1:19 pm

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:

Code: Select all
Get-Counter -ComputerName server -ListSet "*sql*


I have all the performance monitors listed yet I still get the error, can anyone shed some light for me please.

Cheers.
Lynchie435
 
Posts: 11
Joined: Mon May 20, 2013 9:42 am


Return to SQL Monitor 2

Who is online

Users browsing this forum: No registered users and 0 guests