Intermittent Connection Failure

SQL Server performance monitoring and alerting

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

Intermittent Connection Failure

Postby Wren » Fri May 04, 2012 11:15 am

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.
Wren
 
Posts: 3
Joined: Fri May 04, 2012 11:10 am

Postby Brian Donahue » Mon May 07, 2012 11:12 am

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.
Brian Donahue
 
Posts: 6670
Joined: Mon Aug 23, 2004 10:48 am

Postby Wren » Tue May 08, 2012 4:50 pm

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.
Wren
 
Posts: 3
Joined: Fri May 04, 2012 11:10 am

Postby Brian Donahue » Tue May 08, 2012 5:56 pm

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 ... 93110.aspx
Brian Donahue
 
Posts: 6670
Joined: Mon Aug 23, 2004 10:48 am

Resoved

Postby Wren » Tue May 15, 2012 11:02 am

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.
Wren
 
Posts: 3
Joined: Fri May 04, 2012 11:10 am

Postby Brian Donahue » Tue May 15, 2012 2:29 pm

Wonderful! I'm happy to have helped.
Brian Donahue
 
Posts: 6670
Joined: Mon Aug 23, 2004 10:48 am


Return to SQL Monitor 3

Who is online

Users browsing this forum: No registered users and 0 guests