How can we help you today? How can we help you today?

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 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?
dwalkerw
0

Comments

3 comments

Sort by
  • 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
    priyasinha
    0
  • 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.
    dwalkerw
    0
  • 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
    priyasinha
    0

Add comment

Please sign in to leave a comment.