Gap in collected data

dwalkerw

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 yesterday. My problem is that the monitor failed to return any data for about 5 minutes during the outage. I received no data either from the server or the SQL service. The monitor did not indicate any problems during this time.

The only thing of notice is a series of 12 Blocked processes just prior, but they all resolved themselves quickly and were marked as Ended.

Any idea why the data collection failed at just the point I needed the data?

priyasinha

Hi,

If the SQL Server is refusing connection then most probably SQL Monitor was also not able to connect to the SQL Server also hence it didn't collect any data.

When this happened was SQL Monitor still connected to this particular SQL Server or had connection errors?

Thanks,
Priya

dwalkerw

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.

priyasinha

These are timeout errors from SQL Server. This indicates that SQL Monitor was also timing out which explains why there is no data.

Regards,
Priya