Red Gate forums :: View topic - Intermittent Connection Failure
Return to www.red-gate.com RSS Feed Available

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

Intermittent Connection Failure

Search in SQL Monitor 3 forum
Post new topic   Reply to topic
Jump to:  
Author Message
Wren



Joined: 04 May 2012
Posts: 3

PostPosted: Fri May 04, 2012 11:15 am    Post subject: Intermittent Connection Failure Reply with quote

Hello, I have only just installed SQL monitor in our place so I am still learning it. I have just set up a number of machines each with a number of instances on it, but one particular is giving me some problems.

The connection is intermittent with the following error...
Bad Data InvalidDataException column procc.cpu has negative value, but negative values are not allowed.

I am not sure where this data is, has anybody else has this message before? I am monitoring one other instance on the same machine and this is ticking over with no errors. I am monitoring SQL 2005 R2 RTM.

Thank you in advance for any help.
Regards,
W.
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6677

PostPosted: Mon May 07, 2012 11:12 am    Post subject: Reply with quote

Hello,

No doubt your performance counters on one of the SQL Servers have bad data in them, as you can't have "negative" CPU usage. I have no idea what could have caused this - maybe it's some virtual machine issue?

You can try going to the SQL Server computer and rebuilding the default Windows counters using LODCTR.exe /R.
Back to top
View user's profile Send private message
Wren



Joined: 04 May 2012
Posts: 3

PostPosted: Tue May 08, 2012 4:50 pm    Post subject: Reply with quote

Hello Brian,

I tried the lodctr.exe /r which said it ran successfully, but it is still disconnecting, I now have an error that says alot of the perfmon data is missing objects, namely all the SQL ones. How can I get these back?

Regards,
W.
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6677

PostPosted: Tue May 08, 2012 5:56 pm    Post subject: Reply with quote

To rebuild SQL performance counters, use lodctr.exe with the performance counter ini files shipped in SQL Server. Here are some instructions for doing that: http://blogs.msdn.com/b/john_daskalakis/archive/2009/05/07/9593110.aspx
Back to top
View user's profile Send private message
Wren



Joined: 04 May 2012
Posts: 3

PostPosted: Tue May 15, 2012 11:02 am    Post subject: Resoved Reply with quote

Hello Brian,

Just to help others I thought I'd finish off the thread, this did solve my issue, but I did not have to go the extra step to replace the SQL counters, the server had to be restarted (for other reasons) and the SQL counters got re-registered automatically as a result of the restart. SQL Monitor is now connected and monitoring the instance nicely.

Thank you for your help.

Regards,
W.
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6677

PostPosted: Tue May 15, 2012 2:29 pm    Post subject: Reply with quote

Wonderful! I'm happy to have helped.
Back to top
View user's profile Send private message
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