Timeout when opening connection? : The Official Microsoft ASP.NET Forums

Reply

mm8

Member

125 Points

578 Posts

Timeout when opening connection?

Oct 06, 2010 07:40 AM|LINK

I get this error message in the EventViewer every now and then:

Exception information:
    Exception type: SqlException
    Exception message: Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.
 

Request information:
    Request URL: http://x/x.aspx
    Request path: /x.aspx
    User host address: xx
    User:
    Is authenticated: False
    Authentication Type:
    Thread account name: NT AUTHORITY\NETWORK SERVICE
 

Thread information:
    Thread ID: 19
    Thread account name: NT AUTHORITY\NETWORK SERVICE
    Is impersonating: False
    Stack trace:    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 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.GridView.OnPreRender(EventArgs e)
   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)

Does it have something to do with pooling? Is it the connection or the command that times out? When to not use pooling?

Reply

ignatandrei

All-Star

135231 Points

21695 Posts

Moderator

MVP

Re: Timeout when opening connection?

Oct 06, 2010 08:15 AM|LINK

timeout means too many connections. Do a load test and see how many connections do you open.

My .NET blog : http://msprogrammer.serviciipeweb.ro/ |2012 Programmer tools

Reply

mm8

Member

125 Points

578 Posts

Re: Timeout when opening connection?

Oct 06, 2010 10:01 AM|LINK

How to do such a load test? Through Visual Studio?

Reply

ignatandrei

All-Star

135231 Points

21695 Posts

Moderator

MVP

Re: Timeout when opening connection?

Oct 06, 2010 10:56 AM|LINK

mm8
Through Visual Studio

Unfortunately I do not have here VS . But you can do it with

1. NUnit ( start "iexplore <address>")

2. NUnitAsp or Selenium or Watin - to test buttons, textboxes , and so on

I suggest 1 first - opening 50 browsers from a pc and , in the same time, 50 browsers from another .

You can also monitor connections in SqlServer and open a single page and making clicks.How many connection per click / action do you open ? From where?

My .NET blog : http://msprogrammer.serviciipeweb.ro/ |2012 Programmer tools