TimeOut Expired

Question

0.00/5 (No votes)

See more:

SQL

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

In the asp.net I've encountred with the above error. when in my web application I clicked on my link a stored procedure of my DB will run. But the next page don't show. I did these jobs but it didn't solve:
1. Change session time out
2. change connect time out in connection string
3. change application pool setting from integrated to classic
but unfortunately my problem still remain.

Visual studio 2008. asp.net
thank you.

Posted 22-Jul-10 3:37am

Mos_newview

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Sandeep Mewara · Answer 1 · 2010-07-22T03:49:00

Instead of tryign various timeouts, your first step should be to get the bottleneck!

Use Debugger and get the place/reason where the response is taking to long a time. It might be getting the data from DB, some BLL processing or UI level rendering.

Based on your question, chances are with DB. So, run the SP in your DB with the same parameters and check how much time does it take in general. If that fits in and looks like proper timeout place then start working on it.

If you are using simple SQL server to get data, check for all the places where timeouts can be configured. SQL Connection timeout, timeout in DB, then based on the timeouts in SQL layer, you would need to set the same or higher for your UI such that response passes on smoothly.