How to solve timeout problem?

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • BVM
    #1

    How to solve timeout problem?

    Hi, All:

    I have this error. It seems execution time is too long. Actually the execution time is about 30 seconds(I tested in Query analyzer). How do I solve this problem?

    System.Web.Serv ices.Protocols. SoapException: System.Web.Serv ices.Protocols. SoapException: Server was unable to process request. ---> System.Data.Sql Client.SqlExcep tion: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
    at System.Data.Sql Client.SqlComma nd.ExecuteReade r(CommandBehavi or cmdBehavior, RunBehavior runBehavior, Boolean returnStream)
    at System.Data.Sql Client.SqlComma nd.System.Data. IDbCommand.Exec uteReader(Comma ndBehavior behavior)
    at System.Data.Com mon.DbDataAdapt er.Fill(Object data, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
    at System.Data.Com mon.DbDataAdapt er.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
    at System.Data.Com mon.DbDataAdapt er.Fill(DataSet dataSet, String srcTable)
    --- End of inner exception stack trace ---


    Thanks,

    Dennis Huang

    Tags: None
    • Andrew Gnenny
      #2
      Re: How to solve timeout problem?

      Hi,

      I think, to solve such problem you could adjust "SQL Server Properties->Query time-out" value using SQL Server Enterprise Manager or 'sp_configure' system stored procedure. By default this value = 30 seconds.
      Also, do not forget to set correct value for SqlCommand.Comm andTimeout (again, the default value is 30 seconds).
      --
      Andrew Gnenny
      X-Unity Test Studio
      http://x-unity.miik.com.ua/teststudio.aspx

      Bring the power of unit testing to VS .NET IDE


      "BVM" <DennisH@TBH.co m.au> wrote in message news:uhmqmnJiDH A.1508@TK2MSFTN GP10.phx.gbl...
      Hi, All:

      I have this error. It seems execution time is too long. Actually the execution time is about 30 seconds(I tested in Query analyzer). How do I solve this problem?

      System.Web.Serv ices.Protocols. SoapException: System.Web.Serv ices.Protocols. SoapException: Server was unable to process request. ---> System.Data.Sql Client.SqlExcep tion: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
      at System.Data.Sql Client.SqlComma nd.ExecuteReade r(CommandBehavi or cmdBehavior, RunBehavior runBehavior, Boolean returnStream)
      at System.Data.Sql Client.SqlComma nd.System.Data. IDbCommand.Exec uteReader(Comma ndBehavior behavior)
      at System.Data.Com mon.DbDataAdapt er.Fill(Object data, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
      at System.Data.Com mon.DbDataAdapt er.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
      at System.Data.Com mon.DbDataAdapt er.Fill(DataSet dataSet, String srcTable)
      --- End of inner exception stack trace ---


      Thanks,

      Dennis Huang

        Comment

        Previous template Next
        Working...