Hi,

I am getting SQL Time out exception after long run of 15-20 Hours, Please find the attachment for more details.

My SQL queries  are not taking much time for execution , simple Update /Insert statements to local database.

Observed Activity manager also, looks fine.

One more application connected to same database (Insert statements)works fine.

In connection string I have modified Connection string ConnectTimeout = 2147483647; (max)

regards

Venkatesh

1) index fragmentation and rebuild or reorganize index

2) find missing indexes

3) updates statics

4) see cpu and ram index

5) try use temp tables for temporary operation

6) see blocking and locking and try to avoid it.

check and confirm

Venkatesh - You may have set connection timeout not command timeout and it might be possible that query is timing out after waiting for default timeout value which is 30 seconds (Not sure).

Did you check if any blocking is happening at the moment when the query timed-out?