Activity overview
Latest activity by dwalkerw
Upgrade Health Monitor to 7.0.7.7367 failed
The web page will not display. The services are all showing running, and I have tried restarting them. I cannot bring up the health monitor login page. I get a page cannot be displayed screen. I ha...
Can't connect to this server — it might be offline.
After upgrading to 1.5.1.1125, my DEV instance connection is now failing with the error message "Can't connect to this server — it might be offline.
Check that the details below are correct." I h...
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...
Detecting agent jobs still running but excessivly long
I need a way to detect Agent jobs that are still running, but have exceeded their normal times. I have an occasional maintenance task that runs excessively long and gets into the business day. I ne...
One unread alert stuck on
The health monitor constantly shows one unread alert that I cannot get cleared. It appears at the server level, but not on any of the instances. Any ideas on how to get this cleared out?
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-...
Gap in collected data
I have a SQL server that is having spells where it refuses connections for periods of time. I had my company purchase SQL Monitor to help diagnose this problem. I had one of these spells late yeste...