False Alert - Monitoring error (SQL Server data collection)

SQL Server performance monitoring and alerting

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

False Alert - Monitoring error (SQL Server data collection)

Postby jonwilk » Mon May 09, 2011 8:37 am

Hi

We're monitoring a SQL server that is receiving shipped transaction logs. This seems to randomly cause "Monitoring error (SQL Server data collection) (Raised - High)" Alerts to be raised.

I managed to catch one of these and looked at the conf log screen which showed this error:

9 May 2011 8:30 AM SQL #LVG Cannot connect SqlException Database 'xxxx' is being recovered. Waiting until recovery is finished.

As we're shipping a number of databases, this seems to show up quite frequently.

Is there anyway to customise the timeout period that this alert is configured to? Ie if we can increase it to wait at least 5 mins then it should stop all of the false alarms?

Many thanks
jonwilk
 
Posts: 18
Joined: Fri Sep 09, 2005 3:25 pm

Postby priyasinha » Mon May 09, 2011 12:10 pm

Hi,

Thanks a lot for your message.

Unfortunately, the current released version doesn't support any time period configuration for this alert. But we have implemented time tolerance for these alerts internally. This will be released as part of V 2.3 release which is due very soon.

Apart from these, we will also try to reproduce the scenario which you have described. Ideally, SQL Monitor should be able to handle databases which are restoring. Will post here after our investigation.

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

Still don't see the functionality to customize

Postby retracement » Tue Mar 26, 2013 11:54 am

I still don't seem to be able to find the functionality to customize alerts for timeouts (as indicated in this thread to be introduced in the next version). This currently means that a regular daily task is to clear down hundreds of false alerts generated from sqlmonitor. Am I missing something or can we still not change the alert timeout for this event? We are running version 3.
Regards,
Mark Broadbent.
Contact me through twitter: http://www.twitter.com/retracement | blog : http://tenbulls.co.uk | SQLCloud: http://sqlcloud.co.uk
retracement
 
Posts: 1
Joined: Tue Mar 26, 2013 11:49 am
Location: Cambridge

Postby priyasinha » Fri Apr 12, 2013 10:27 am

Hi,

We do not allow customizing Monitoring error alert because they are important for the SQL Monitor to work as expected.

I would suggest that you investigate that why you are getting so many Monitoring error alerts. These alerts come up when any data collection fails. It is worth looking at the Base Monitor log files to see what data collection is failing and then investigating why?

Also, it is worth posting questions in SQL Monitor 3 forum and not SQL Monitor 2 forum. SQL Monitor 3 forum is active now and we would be responding much qucikly to question in that forum.

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


Return to SQL Monitor 2

Who is online

Users browsing this forum: No registered users and 1 guest