Red Gate forums :: View topic - 3.1.0.125: Monitoring Stopped 1 sec - no auto restart
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

3.1.0.125: Monitoring Stopped 1 sec - no auto restart

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



Joined: 25 Jul 2005
Posts: 499
Location: Costa Mesa, CA, USA

PostPosted: Mon Jul 02, 2012 7:09 pm    Post subject: 3.1.0.125: Monitoring Stopped 1 sec - no auto restart Reply with quote


    Machine authentication failed at: 1 Jul 2012 12:35:25 AM
    Machine authentication successful at: 1 Jul 2012 12:35:26 AM

    No performance data available for this host machine or SQL Server instance in this time range.
The explanation page reads CONTRARY to what the Configuration page shows - a RED X against "local" (last row).
    Raised when monitoring stops because the user name or password you entered for SQL Monitor to connect to your host machine fails authentication. Check whether:

    Your user name or password have changed. NO THEY HAVEN'T!
    Your permissions have changed and are no longer sufficient. NO THEY HAVEN'T!
    Once the correct credentials are entered and authentication is successful, monitoring will resume and the alert will be marked automatically as Ended. THE ALERT IS MARKED AS ENDED 1 SECOND AFTER IT WAS RAISED!
This is a break of 1 SECOND. Due to multiple prior issues with Windows Authentication, we decidedupon using the HAMMER of the sa login - a password set in concrete (here) and a login that's always there (for us) and doesn't care a bit about Windows AD. The third line above is COMPLETELY FALSE - NO performance data gathering PERIOD UNTIL THE PASSWORD IS RE-APPLIED!

For SQL Monitor to NOT self-repair after a single 1 second break seems, sorry to use the word, LUDICROUS! I only discovered this after SQL Monitor had been NOT collecting performance data for 36 hours (server is on EDT, I'm on PDT).

PLEASE, make it fix itself!
Back to top
View user's profile Send private message
Manfred.Castro



Joined: 23 Apr 2012
Posts: 205

PostPosted: Tue Jul 03, 2012 10:23 pm    Post subject: Reply with quote

The default behaviour for SQL Monitor is to disconnect if it encounters an authorization error.
There is however a work around to get SQL Monitor to retry the connection if for some reason it encounters this error.
Edit c:\programdata\red gate\sql monitor 3\RedGate.Response.Engine.Alerting.Base.Service.exe.Settings.config
Under <configuration>, set <reconnectAfterAuthorizationError > to true
restart the Base Monitor service
_________________
Manfred Castro
Product Support
Red Gate Software
Back to top
View user's profile Send private message
PDinCA



Joined: 25 Jul 2005
Posts: 499
Location: Costa Mesa, CA, USA

PostPosted: Tue Jul 03, 2012 10:43 pm    Post subject: Reply with quote

Sadly, I already have that set to true:
Code:
    reconnectAfterAuthorizationError
    *********************
 
    Whether SQL Monitor should try to reconnect and continue monitoring after an AuthorizationError is raised
  -->
   <repositorySettings slaveMode="false">
      <!-- valid databaseEngines: "Mssql"-->
      <dataStore databaseEngine="Mssql" autoUpgrade="true">
         <!-- valid versions: "Auto", "SQL2005", "SQL2008" -->
         <mssql version="Auto" connectionStringName="DataConnectionString"/>
      </dataStore>
   </repositorySettings>
   <collectionSettings maxTraceFileAge="00:15:00" maxTraceFileDiskUsage="1024" reconnectAfterAuthorizationError="true">
      <collectionSchedules>
Bug?
Back to top
View user's profile Send private message
Manfred.Castro



Joined: 23 Apr 2012
Posts: 205

PostPosted: Tue Jul 10, 2012 10:10 pm    Post subject: Reply with quote

Try
Edit c:\programdata\red gate\sql monitor 3\RedGate.Response.Engine.Alerting.Base.Service.exe.Settings.config
Under <configuration>, add <reconnectAfterAuthorizationError />
restart the Base Monitor service
_________________
Manfred Castro
Product Support
Red Gate Software
Back to top
View user's profile Send private message
PDinCA



Joined: 25 Jul 2005
Posts: 499
Location: Costa Mesa, CA, USA

PostPosted: Tue Jul 10, 2012 10:55 pm    Post subject: Reply with quote

Sorry, Manfred, your post doesn't make it clear to me just WHERE one should place what looks like (to me) an empty element.

Would you be so kind as to post a sample like mine, 2 posts above, that shows the suggestion in place, please?
Back to top
View user's profile Send private message
chriskelly



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

PostPosted: Tue Jul 17, 2012 11:34 pm    Post subject: Reply with quote

The reconnectAfterAuthorizationError tag is used when to connection to a monitored entity drops out due to an authorisation error. It is not always clear why this happens, but when the auto retry occurs it reconnects without issue. However, in scenarios where this does not happen then this configuration can be dangerous which is why it is set to "false" by default and must be manually changed. So from your description, it looks like the configuration has done its job (as reflected by the fact that the alert status switched to Ended within a second [it is rounded to the nearest second in the alert]).

However, the fact that the performance data did not restart collection would point to a different issue. It may well be triggered by the authorization error, but I don't think it is caused by it. Therefore, please can you send the SQL Monitor error logs to support@red-gate.com (see doc below). Please ensure that you send the logs which cover the 1st July 2012. Can you also make sure that you include the support ticket number F0061979 in the subject line so that it comes to me.
http://www.red-gate.com/supportcenter/content/SQL_Monitor/help/3.1/SM_LogFiles
_________________
Chris Kelly
Technical Support Engineer
Back to top
View user's profile Send private message
PDinCA



Joined: 25 Jul 2005
Posts: 499
Location: Costa Mesa, CA, USA

PostPosted: Wed Jul 18, 2012 6:43 pm    Post subject: Reply with quote

Logs emailed.

Thanks, Chris.
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