Error Message: Timeout expired.

[Victor]

Hello there,

I have about 50 users who use an asp.net application i made. For a
while there were no problems but now i see a lot of timeout expired
messages i diiferent forms of my application. See the stack trace
below:
What can i do to avoid this?

Thnx in advance,
Victor

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

Page Error Occured: /webgabprod/Administration/administration.aspx

ExceptionType: System.Data.SqlClient.SqlException

Stack trace: at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior
cmdBehavior, RunBehavior runBehavior, Boolean returnStream)

at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior
behavior)

at System.Data.SqlClient.SqlCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior
behavior)

at System.Data.Common.DbDataAdapter.FillFromCommand(Object data,
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)

at WebGab.WebForm1.GetAanvragen()

at WebGab.WebForm1.btn_zoek_Click(Object sender, EventArgs e)

at System.Web.UI.WebControls.Button.OnClick(EventArgs e)

at System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String
eventArgument)

at System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler
sourceControl, String eventArgument)

at System.Web.UI.Page.RaisePostBackEvent(NameValueCollection
postData)

at System.Web.UI.Page.ProcessRequestMain()

 

[Joyjit Mukherjee]

Hi,

Are you sure you are releasing the connections to the pool properly after
using it. There may be a memory leak if you don't. See more in
http://weblogs.asp.net/angelsb/archive/2004/08/25/220333.aspx

Regards
Joyjit

 

[Miha Markic [MVP C#]]

Hi Victor,

How are you using connection object (are you creating new instance all the
time - correct way).
Is somebody locking the database perhaps? Using a long transaction?