Red Gate forums :: View topic - Perfmon Bad data error
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Monitor 2
SQL Monitor 2 forum

Perfmon Bad data error

Search in SQL Monitor 2 forum
Post new topic   Reply to topic
Jump to:  
Author Message
Rhys



Joined: 01 Dec 2010
Posts: 21

PostPosted: Wed Dec 01, 2010 1:26 pm    Post subject: Perfmon Bad data error Reply with quote

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?
Back to top
View user's profile Send private message
priyasinha



Joined: 03 Jan 2007
Posts: 530

PostPosted: Wed Dec 01, 2010 2:37 pm    Post subject: Reply with quote

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
Back to top
View user's profile Send private message
Rhys



Joined: 01 Dec 2010
Posts: 21

PostPosted: Wed Dec 01, 2010 4:42 pm    Post subject: Reply with quote

Hi Priya

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

Rhys
Back to top
View user's profile Send private message
priyasinha



Joined: 03 Jan 2007
Posts: 530

PostPosted: Wed Dec 01, 2010 5:15 pm    Post subject: Reply with quote

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
Back to top
View user's profile Send private message
Baguck



Joined: 26 Jul 2012
Posts: 4
Location: USA - North Carolina

PostPosted: Thu Jul 26, 2012 7:51 pm    Post subject: Reply with quote

*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
Back to top
View user's profile Send private message
priyasinha



Joined: 03 Jan 2007
Posts: 530

PostPosted: Fri Jul 27, 2012 9:16 am    Post subject: Re: Reply with quote

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
Back to top
View user's profile Send private message
Lynchie435



Joined: 20 May 2013
Posts: 11

PostPosted: Wed May 22, 2013 1:19 pm    Post subject: Sorry for also bringing this up but I have a similar issue. Reply with quote

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:
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.
Back to top
View user's profile Send private message Send e-mail
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group