troubleshooting Question

SQL Server Timeout issue when updating one row

Avatar of samahe
samahe asked on
16 Comments1 Solution501 ViewsLast Modified:

I need help fixing the following issue:

In some cases users of my websiteI get the following error message "Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding." when updating their own data. (Meaning: no mass update, but only updating a row at a time).

The issue only occurs on some of the records but if it has started happening on a record it will always timeout from then on. Just like it would remain locked forever or as if the data was broken somehow.

The StackTrace looks like this:
   at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at MyOwnNamespace.WLDB.UpdateWLText(Int32 WLID, String Text1, String Text2)
   at ASP.EditWL_aspx.btnSafe_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()

Any  ideas? Please help.
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 16 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 16 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros