Retry Connection after Monitoring Stopped

SQL Server performance monitoring and alerting

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

Retry Connection after Monitoring Stopped

Postby ScottHerbert » Tue Jan 03, 2012 11:47 pm

Hi,

Is there a way to configure an amount of time after which SQL Monitor will attempt to reconnect to a server which has become unreachable?

We are monitoring a SQL2008R2 Failover Cluster which sits on clustered Server 2008R2 servers.

When a physical (i.e. Windows Server) failover occurs, we get "Machine Unreachable" and monitoring stops. I'd like to see SQL Monitor retry the connection say 10 minutes later, rather than waiting for me to notice and re-enable the next day.
ScottHerbert
 
Posts: 13
Joined: Fri Oct 07, 2011 12:06 am
Location: Canberra

Postby priyasinha » Wed Jan 04, 2012 12:26 pm

Hi Scott,

SQL Monitor keeps trying to connect after every monitoring error including 'Unreachable', 'Connection failed' except when it is 'Monitoring stopped (Incorrect credentials or insufficent permission)'. The reason SQL Monitor doesn't try to connect after 'Monitoring stopped (Incorrect credentials or insufficent permission)' is that we dont want to fill security log with failed login. If you have a intrusion detection system in your environment then it may get triggered because of that.

But having said this, we do have a workaround for that i.e. SQL Monitor will keep trying to connect even after 'Monitoring stopped (Incorrect credentials or insufficent permission)'. Though we do not recommend this but I will send you detail in email. You can then decide whether you would like to make this change for your environment or not. If you do not receive my email in next 1/2 hour then please let us know.

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

Postby ScottHerbert » Wed Jan 04, 2012 11:00 pm

Thanks Priya, that makes sense as to why it's been implemented like that.
ScottHerbert
 
Posts: 13
Joined: Fri Oct 07, 2011 12:06 am
Location: Canberra

Postby niehrx » Thu Jan 26, 2012 4:37 pm

Hi Scott,

I have the same case as priyasinha. It would be best if it would automatically reconnect because we are using email alert. how can it raise an email alert if monitoring stopped?

Can you send to me the workaround for this too?

Thanks.
niehrx
 
Posts: 3
Joined: Thu Jan 26, 2012 4:22 pm

Re:

Postby priyasinha » Thu Jan 26, 2012 5:55 pm

niehrx wrote:Hi Scott,

I have the same case as priyasinha. It would be best if it would automatically reconnect because we are using email alert. how can it raise an email alert if monitoring stopped?

Can you send to me the workaround for this too?

Thanks.


Hi,

I have emailed you just now.

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

Reconnect

Postby Chrish » Thu Feb 02, 2012 10:30 am

Hi Priya,

We are also experiencing similar problems to Scott. Intermittently the remote server login credentials will fail and return 'Monitoring stopped (Incorrect credentials or insufficent permission)', when we try and reconnect seconds later it is fine so I think your workaround will work for our scenario.

Please could you e-mail me the workaround as well?

Many thanks,

Chris.
Chrish
 
Posts: 9
Joined: Thu Jun 30, 2011 4:45 pm
Location: Cambridgeshire

Postby Chris Spencer » Thu Feb 02, 2012 11:40 am

Hi Chris

I've emailed you some instructions.

Regards
Chris
Chris Spencer
Test Engineer
Red Gate
Chris Spencer
 
Posts: 301
Joined: Tue Aug 29, 2006 9:09 am
Location: Red Gate - Cambridge

Re:

Postby Chrish » Tue Feb 07, 2012 1:27 pm

Chris Spencer wrote:Hi Chris

I've emailed you some instructions.

Regards
Chris


Hi Chris,

Received the e-mail.

Many thanks for your help.

Cheers,

Chris.
Chrish
 
Posts: 9
Joined: Thu Jun 30, 2011 4:45 pm
Location: Cambridgeshire

Postby Irina » Fri Mar 02, 2012 6:26 pm

Hi Priya,
We are having the same issue.
Could you also send me the work around?

Thanks,
Irina
Irina
 
Posts: 1
Joined: Fri Mar 02, 2012 6:20 pm

Re:

Postby Chris Spencer » Fri Mar 02, 2012 6:37 pm

Irina wrote:Hi Priya,
We are having the same issue.
Could you also send me the work around?

Thanks,
Irina


Email has been sent.

Regards
Chris
Chris Spencer
Test Engineer
Red Gate
Chris Spencer
 
Posts: 301
Joined: Tue Aug 29, 2006 9:09 am
Location: Red Gate - Cambridge

Postby SQLWhat » Thu Mar 15, 2012 4:36 pm

Hi All,
I am having these exact same issues. I thought it was a DNS problem at first and modifying the hosts file for all monitored servers worked for a little bit but it seems to be doing it again.

Could I be sent the instructions as well?

Thank you,
Bruce
SQLWhat
 
Posts: 1
Joined: Thu Mar 15, 2012 4:34 pm

Re:

Postby Chris Spencer » Thu Mar 15, 2012 4:42 pm

SQLWhat wrote:Hi All,
I am having these exact same issues. I thought it was a DNS problem at first and modifying the hosts file for all monitored servers worked for a little bit but it seems to be doing it again.

Could I be sent the instructions as well?

Thank you,
Bruce


Email sent

Regards
Chris
Chris Spencer
Test Engineer
Red Gate
Chris Spencer
 
Posts: 301
Joined: Tue Aug 29, 2006 9:09 am
Location: Red Gate - Cambridge

Monitoring stopped on reboot?

Postby Random Lengths » Tue Mar 20, 2012 4:31 pm

I wonder if I'm having the same problem: Every time I reboot the SQL Server (for maintenance) The monitor stops, and never restarts. It certainly isn't invalid credentials since it's just a reboot, so I'm really doubting it's still trying 10 minutes later.

I would like these instructions as well, if you think this is my issue.

Thanks,
Dan
Random Lengths
 
Posts: 28
Joined: Mon Sep 29, 2008 11:02 pm
Location: Eugene, OR

Can I get the instructions as well ?

Postby devdtd » Fri Mar 30, 2012 3:25 pm

Can I get the instructions as well ? I am having the same issues .

Thank you


donald.dixon@ttx.com
devdtd
 
Posts: 1
Joined: Fri Mar 30, 2012 3:24 pm

Re: Monitoring stopped on reboot?

Postby Chris Spencer » Fri Mar 30, 2012 3:34 pm

Random Lengths wrote:I wonder if I'm having the same problem: Every time I reboot the SQL Server (for maintenance) The monitor stops, and never restarts. It certainly isn't invalid credentials since it's just a reboot, so I'm really doubting it's still trying 10 minutes later.

I would like these instructions as well, if you think this is my issue.

Thanks,
Dan


Email sent. Apologies for the delay.

Regards
Chris
Chris Spencer
Test Engineer
Red Gate
Chris Spencer
 
Posts: 301
Joined: Tue Aug 29, 2006 9:09 am
Location: Red Gate - Cambridge

Next

Return to SQL Monitor 2

Who is online

Users browsing this forum: No registered users and 0 guests

cron