timeout error

  • Thread starter Thread starter simon
  • Start date Start date
S

simon

I have ASP.NET application.

This application performs very well for 99% of the time
but occasionally I get the following error message:

The timeout period elapsed prior to completion of the operation or the
server is not responding

The proc that is executing is doing a SELECT only.

How can I solve this problem?

Thank you,
Simon
 
How long does the query take to execute outside of asp.net? (like from
Query Analyzer).

If the query is taking 5 minutes to execute you'll need to figure out
why. Does it try to return 10 million records?

If it takes a long time to return just 5 records, perhaps it needs an
index: http://odetocode.com/Articles/237.aspx
 
Back
Top