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

Question

1.00/5 (1 vote)

See more:

Dear All,

i have search some field on the basis of customer name.

when i search in sql server management studio it filter record,and take time aprox 25 sec.
when i search by the portal it gives 0 record
or
Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.

how to solve it please help me.

thanks

Posted 18-Jun-12 1:11am

DINESH K MAURYA

Add a Solution

Comments

AshishChaudha 18-Jun-12 7:31am

How do we know what query you are executing in sql server...how many records are there in your portal..have you used indexing in your table from which you are searching records???

DINESH K MAURYA 18-Jun-12 8:08am

record 17543 rows,
i am not using index
but when i search all record it working fine.

2 solutions

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)

OriginalGriff · Answer 1 · 2012-06-18T01:37:00

It may be that your "portal" server has an execution timeout set, and that your query is exceeding that limit. If you query takes 25 seconds to complete on SSMS, then it is an indication that the query is to complex, or you have a problem with your database design.

Without knowing the size of your DB, and any indexes, and the nature of your query we can't be more specific.

barneyman · Answer 2 · 2012-06-18T02:36:00

A couple of basic 'rules of thumb' that have helped me with SQL over the years

1. If a query takes more than 2-3 seconds, appropriate indices are missing
2. If a query takes more than 8-10 seconds, the query is fundamentally flawed AND indices are broken; redesign query, introduce temp tables, see rule #1
3. If a query takes more than 15 seconds, there's a lock contention somewhere, or I should really seek another career; check concurrent activity and see rule #2

Query Analyser is your friend ... use it

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

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0