Comments
Sort by recent activity
We will be upgrading from SQL 2008 to 2014 in the next month or two. We still have not had a reoccurring issue with the backups hanging since Hyperback was disabled. We will consider the need for Backup Pro as part of this upgrade.
Dennis / comments
We will be upgrading from SQL 2008 to 2014 in the next month or two. We still have not had a reoccurring issue with the backups hanging since Hyperback was disabled. We will consider the need for B...
I did find the Job Duration Unusual custom metric after I posted this request. I am working on adjusting the times so the alerts are not throwing off false warnings. This may do the job. The Long Running Queries does not see to pickup the backups.
What prompted this is appearing to be a problem with Hyper Back, which I understand is now not supported anymore. We were having problems with backups hanging, and tying up backups across all instances of SQL on the same server. I disabled this service last week, and have not had another occurrence since. We will either upgrade Hyper Back to the newer product, or upgrade SQL to 2014 where compression is natively supported. / comments
I did find the Job Duration Unusual custom metric after I posted this request. I am working on adjusting the times so the alerts are not throwing off false warnings. This may do the job. The Long R...
I see errors as follows:
Event Type: Error
Event Source: SQL Monitor 2
Event Category: None
Event ID: 0
Date: 12/22/2010
Time: 12:00:21 PM
User: N/A
Computer: INMUNCBEENAS2
Description:
2010-12-22 17:00:21,125 [40] ERROR RedGate.Response.Engine.Monitoring.Core.JobScheduler [(null)] - NHibernate.TransactionException: Begin failed with SQL exception ---> System.Data.SqlClient.SqlException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
at System.Data.SqlClient.SqlConnection.Open()
at NHibernate.Connection.DriverConnectionProvider.GetConnection()
at NHibernate.AdoNet.ConnectionManager.GetConnection()
at NHibernate.Impl.SessionImpl.get_Connection()
at NHibernate.Transaction.AdoTransaction.Begin(IsolationLevel isolationLevel)
--- End of inner exception stack trace ---
at NHibernate.Transaction.AdoTransaction.Begin(IsolationLevel isolationLevel)
at NHibernate.Transaction.AdoTransaction.Begin()
at NHibernate.AdoNet.ConnectionManager.BeginTransaction()
at NHibernate.Impl.SessionImpl.BeginTransaction()
at (Object )
at #cnv.#wnv..ctor(ISession )
at #cnv.#bnv.#Ool()
at #5mv.#eov.#fDv(#hjv , #hjv , Boolean )
at #5mv.#eov.#t.#B3.#bcz()
at #tmv.#Hov.#t.#Iov.Execute(JobExecutionContext )
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp. / comments
I see errors as follows:
Event Type: Error
Event Source: SQL Monitor 2
Event Category: None
Event ID: 0
Date: 12/22/2010
Time: 12:00:21 PM
User: N/A
Computer: INMUNCBEENAS2
Description:
2010-12-...