Red Gate forums :: View topic - Monitoring error occured so frequent
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

Monitoring error occured so frequent

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



Joined: 13 Sep 2012
Posts: 6

PostPosted: Tue Oct 16, 2012 8:34 am    Post subject: Monitoring error occured so frequent Reply with quote

We are monitoring 9 SQL servers but I found some of them keeps getting the following errors some days ago:
Monitoring error (SQL Server data collection)
Monitoring stopped (host machine credentials)


Yesterday afternoon when this error occured three times I checked the event log and found this exception:
15 Oct 2012 5:20 PM WMI OpenNamespace: root\cimv2 Cannot connect COMException Call was canceled by the message filter. (Exception occured at HRESULT: 0x80010002 (RPC_E_CALL_CANCELED))

I have did the testing data collection methods which the Red Gate suggests and checked the network,AD,firewall(always closed),necessary services,etc.
Sadly,I found nothing at last.Can anybody help me with this?
Back to top
View user's profile Send private message
chriskelly



Joined: 19 Apr 2010
Posts: 309
Location: Cambridge, UK

PostPosted: Thu Nov 08, 2012 9:40 pm    Post subject: Reply with quote

The definition of these alerts are:

Monitoring error (SQL Server data collection)
One of the following conditions applies continuously for 2 minutes:
Problems with WMI
Problems with the remote registry
File sharing issues
SQL connectivity issues

Monitoring stopped (host machine credentials)
SQL Monitor is unable to collect monitoring data from the host machine because the credentials supplied to connect to the machine are invalid or lack permissions.

In the case of the first alert, once the condition which caused it to be generated are no longer present the alert will change from Active to Ended. So it looks like you have a problem with the Windows Management Instrumentation protocol which SQL Monitor uses to collect some data from the monitored host machine. Please take a look at the document links which are listed in this document towards the end of the section marked Testing WMI.

The second alert can be a little more difficult to pinpoint. How long does it stay active for? how often does it occur?
_________________
Chris Kelly
Technical Support Engineer
Back to top
View user's profile Send private message
Freman



Joined: 13 Sep 2012
Posts: 6

PostPosted: Fri Nov 09, 2012 1:22 am    Post subject: Re: Reply with quote

Hi Chris,
The two Alerts disappeared some days ago when I reinstalled the Windows OS & SQL Monitor Software.

However,thanks you very much!
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