Timeout expired SQL Execution error

Question

0.00/5 (No votes)

See more:

SQL Execution error

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

How to solve the timeout expired issue?

Posted 14-Sep-12 1:13am

Swathi Nagaraj

Add a Solution

Comments

Malli_S 14-Sep-12 7:16am

In what case does it times out? While connecting or executing ?
If possible show up some code.

Swathi Nagaraj 14-Sep-12 8:16am

when I execute the following lines in server explorer, Raising SQL Execution error
Select Distinct EmployeeId, FName, LName from fn_Employee

3 solutions

Solution 3

Execute the query in Database side and verify where exactly the problem is,

Some of the problem causes,

It may be due to lock of that table,
There is no proper index creation on that table
May be there is a bunch of records like some lacks in that case create a maintainance plan to reorganize the indexes,
If you want the data for OLAP then put a nolock in the query,
Still you face the problem then check your command time out value from your application and change it accordingly.

Posted 14-Sep-12 2:46am

Rajesh Buddaraju

Solution 1

Hi,

I guess your transaction is processing the query on Large data, or some database connection problem may be there. The DB connection you have to find the cause but for the processing the large data below link may help you.

Improve the performance[^]

hope it helps.

Posted 14-Sep-12 1:19am

Karthik Harve

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)

Kuthuparakkal · Accepted Answer · 2012-09-14T01:19:00

Solution 2

Change Connection string to increase time out:

Data Source=SomeDBServer;Initial Catalog=SomeDB;Provider=SQLNCLI10.1;Integrated Security=SSPI;Auto Translate=False;Connect Timeout=60;

Posted 14-Sep-12 1:19am

Kuthuparakkal

Updated 14-Sep-12 1:20am

v3

Comments

Swathi Nagaraj 17-Sep-12 5:55am

sqlcommand.CommandTimeout = 120;

This works fine sometimes, but sometimes rasies time out expired exception.
I want to know the reason, why it doesn't work sometimes?