locked
SQL TimeOut Exception after 15-20 Hours of Continuous Run RRS feed

  • Question

  • 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

    Thursday, April 23, 2015 4:49 AM

Answers

All replies

  • 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

    Thursday, April 23, 2015 6:11 AM
  • 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?


    Good Luck! Please Mark This As Answer if it solved your issue. Please Vote This As Helpful if it helps to solve your issue

    Thursday, April 23, 2015 6:12 AM
  • Hello Venkatesh,

    As Manu already wrote it is a SqlCommand.CommandTimeout (default 30 sec), not a SqlConnection.ConnectionTimeout


    Olaf Helper

    [ Blog] [ Xing] [ MVP]



    Thursday, April 23, 2015 8:03 AM