Problem connecting to SQL Monitor repository data store

JoM

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: