How do you use cloud databases? Take the survey.

Problem connecting to SQL Monitor repository data store

JoMJoM Posts: 1 New member
edited November 16, 2020 12:05PM in Redgate Monitor
Hi,
I have several servers that are being monitored with SQL Monitor 14.
Some of them are in an AO environment and some are on Mirroring.

The problem im having is sometimes i get in the Web GUI "monitoring error"
For 10 minutes in average and then it sorts it self out.
in the GUI log it says: "internal sql monitor error"

the environments are:
SQL Monitor (Base Monitor) : Windows 2012 R2
SQL Servers : 
AO Cluster - Windows 2016
Mirror Cluster - Windows 2012 R2

Can you assist please ?


Attaching the log snipped from SQL Monitor.

2020-11-16 09:00:59,494 [   60] WARN  RedGate.SqlMonitor.Common.Utilities.Scheduling.JobRunner - Unhandled exception in job run: JobRef(DataCollectionScheduler:Root[].[Cluster][[Name]=be-bo-db2.wsldevops.com], IntervalJobSchedule(00:00:10) – [Ping])
System.Exception: Problem connecting to SQL Monitor repository data store
   at RedGate.SqlMonitor.Common.Utilities.Sql.Abstraction.RepositorySqlConnectionProvider.OpenConnectionWithConnectionString()
   at RedGate.SqlMonitor.Engine.Monitoring.Core.Repositories.Sql.SqlDataRepositoryCommitter.CommitToDataRepository(SqlDataRepositoryCommits repositoryCommits)
   at RedGate.SqlMonitor.Engine.Monitoring.Core.Repositories.Sql.SqlDataRepositoryMerger.Merge(ChannelTree`1 rootQueryTree, Channel rootChannel)
   at RedGate.SqlMonitor.Engine.Monitoring.Core.Collection.DataCollector.CollectChannelWithinQueryContext(ChannelTree`1 rootQueryTree, Boolean recurse, IMonitoredEntitiesContext queryContext)
   at RedGate.SqlMonitor.Engine.Monitoring.Core.Collection.DataCollectionSchedule.<>c__DisplayClass11_0.<CreateJobAction>b__3()
   at RedGate.SqlMonitor.Common.Utilities.Scheduling.JobRunner.RunAndReschedule(JobRescheduleEvent jobRescheduleEvent)
Inner exception:
   Microsoft.Data.SqlClient.SqlException: Connection Timeout Expired.  The timeout period elapsed while attempting to consume the pre-login handshake acknowledgement.  This could be because the pre-login handshake failed or the server was unable to respond back in time.  The duration spent while attempting to connect to this server was - [Pre-Login] initialization=42027; handshake=0; 
   [HelpLink.BaseHelpUrl]: 'http://go.microsoft.com/fwlink'
   [HelpLink.EvtID]: '-2'
   [HelpLink.EvtSrc]: 'MSSQLServer'
   [HelpLink.LinkId]: '20476'
   [HelpLink.ProdName]: 'Microsoft SQL Server'
   [Error]: {
     [Class]: '11'
     [LineNumber]: '0'
     [Message]: 'Connection Timeout Expired.  The timeout period elapsed while attempting to consume the pre-login handshake acknowledgement.  This could be because the pre-login handshake failed or the server was unable to respond back in time.  The duration spent while attempting to connect to this server was - [Pre-Login] initialization=42027; handshake=0; '
     [Number]: '-2'
     [Procedure]: ''
     [Server]: 'be-mon-db.wsldevops.com'
     [Source]: 'Core Microsoft SqlClient Data Provider'
     [State]: '0'
   }
      at Microsoft.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection)
      at Microsoft.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection)
      at Microsoft.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)
      at Microsoft.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
      at Microsoft.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry, SqlConnectionOverrides overrides)
      at Microsoft.Data.SqlClient.SqlConnection.Open(SqlConnectionOverrides overrides)
      at RedGate.SqlMonitor.Common.Utilities.Sql.SqlConnectionExtensions.OpenConnectionWithBackoff(IDbConnection connection, IBackoff backoff)
      at RedGate.SqlMonitor.Common.Utilities.Sql.Abstraction.RepositorySqlConnectionProvider.OpenConnectionWithConnectionString()
   Inner exception:
      System.ComponentModel.Win32Exception: The wait operation timed out.
   End of inner exception:
End of inner exception:


Sign In or Register to comment.