Waiting period before the operation is completed, or the server is not responding

Question

We have a production server database and a Widnows Client project. Suddenly we get this error when querying the database.

"Waiting period before the operation is completed, or the server is not responding"

How can we solve this problem from a database / C # Windows side?

Thanks Velusamy

+3

Velu Mar 14 '11 at 19:18

1 answer

Andomar · Accepted Answer · 2011-03-14T20:56:06+0000

Quick and dirty answer: set SqlCommand.CommandTimeoutto a higher value.

Long answer:

Run the request in SSMS with "Show actual execution plan" enabled. Check the result for index tips.
Check database logs for suspicious events
, .

:

SELECT  Object_Name(ind.object_id)
,       ind.name
,       STATS_DATE(ind.object_id, ind.index_id) 
FROM    SYS.INDEXES ind

, , . , () .