mssql11 timeouts

Discussion in 'H-Sphere Reseller Hosting' started by equanimity, May 7, 2009.

  1. equanimity

    equanimity Perch

    I'm getting a lot of timeouts in the last 5 hours ,

    anybody is getting timeouts with sqlserver mssql11?
  2. akshay

    akshay Administrator Staff Member

    We found and corrected that issue also i replied your ticket.
  3. equanimity

    equanimity Perch

    timeouts are here again
  4. equanimity

    equanimity Perch

    why isn't there any about this issue in outage section? I'm having timeouts all day
  5. equanimity

    equanimity Perch

    I'm getting errors continually, timeout mssql11 but I have no answer in my tickets about this issue. This issue is during 10 houres
  6. arijeetneogi

    arijeetneogi Arijeet

    Hello,

    We are constantly monitoring the server making sure there is no further abuse on it .
    The server seems to be stable now.
    We have replied your ticket. Plesae check it.
  7. Stephen

    Stephen US Operations Staff Member

    just FYI,

    we have alerting on your site that uses this server and know when such is happening, the user that caused this has already been sent notice quite a few hours back now.
  8. equanimity

    equanimity Perch

    I have seen more timeouts 20 minutes before last message of Stephen
  9. equanimity

    equanimity Perch

    I'm having timeouts last 8 hours, and right now I have check and I get timeout error. I have resend it to ticket system
  10. equanimity

    equanimity Perch

    some body can investigate this error, please?

    Message: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.

    Stack trace: at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
    at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
    at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
    at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
    at System.Data.SqlClient.SqlDataReader.ConsumeMetaData()
    at System.Data.SqlClient.SqlDataReader.get_MetaData()
    at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
    at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
    at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
    at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
    at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
    at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
    at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
    at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
    at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
    at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable)
    at System.Web.UI.WebControls.SqlDataSourceView.ExecuteSelect(DataSourceSelectArguments arguments)
    at System.Web.UI.DataSourceView.Select(DataSourceSelectArguments arguments, DataSourceViewSelectCallback callback)
    at System.Web.UI.WebControls.DataBoundControl.PerformSelect()
    at System.Web.UI.WebControls.BaseDataBoundControl.DataBind()
    at System.Web.UI.WebControls.GridView.DataBind()
    at System.Web.UI.WebControls.BaseDataBoundControl.EnsureDataBound()
    at System.Web.UI.WebControls.CompositeDataBoundControl.CreateChildControls()
    at System.Web.UI.Control.EnsureChildControls()
    at System.Web.UI.Control.PreRenderRecursiveInternal()
    at System.Web.UI.Control.PreRenderRecursiveInternal()
    at System.Web.UI.Control.PreRenderRecursiveInternal()
    at System.Web.UI.Control.PreRenderRecursiveInternal()
    at System.Web.UI.Control.PreRenderRecursiveInternal()
    at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
  11. equanimity

    equanimity Perch

    we are getting timeouts, and timeouts from mssql11 . Anybody is working with this issue. I have no answer from you X(
  12. akshay

    akshay Administrator Staff Member

    Yes i am still checking it and update you on ticket.
  13. equanimity

    equanimity Perch

    I have no update in my tickets, only "try again", and the issue is going on . I need to know wich is the real cause of all this. Last month was a hardware issue on mssql11, yesterday was a abuse on the server and it was controlled, and today I have no asnwer after 6 houres getting errors

    Why there is not any thread about this issue in the Outage section ? Nobody has mssql11 issue? Sorry but I can not believe it
  14. Stephen

    Stephen US Operations Staff Member

    we are monitoring mssql11 as I said before, every minute, and not seeing such timeouts as you, and in the past we have.

    There was not a hardware error ever on it, there was abuse and a DRIVER issue, which is not hardware, it is software.
    2 users have been given notices on MSSQL11 about abuses, but the server is not seeing any issue over the last 45 minutes when I have been logged in.
  15. equanimity

    equanimity Perch

    I'm sending to you every timeout I get from ASP.NET . It is not continuous but intermittent and random. If i can do something else to try to discover where is the iisue I'll do, but the issue is there.

    Wich is the driver issue? wasn't resolved some weeks ago?
  16. equanimity

    equanimity Perch

    I got right now a timeout. May be a conectivity issue between webserver and mssqlserver? I don't know, but If you say that there is no issue on mssql11, why i get timeouts?
  17. equanimity

    equanimity Perch

    we are in the same situation that 5 days ago. The issue is going on.

    Some solution?

Share This Page

JodoHost - 26,000 hosting end-users in 100 countries
Plesk Web Hosting
VPS Hosting
H-Sphere Web Hosting
Other Services