Post reply

unexpected Error occured in the database server Time out expired

  • June 25, 2013 at 1:14 pm

    #279523

    Hi all ,

    Application team mail me this error...

    I checked the no timeout error in SQL server error log...

    No I/O related error , even eventvwr not showing any thing...

    but this is second time application team saying they are getting this error , plz suggest how to monitor it.

    As i m checking with monitor disk counters and sql buffer counter as it is also normal

    Regards,
    Shivrudra W

  • June 25, 2013 at 1:21 pm

    #1627278

    that's an application error,and not SQL server.

    a lot of applications will have a default connection timeout of 30 seconds, unless someone explicitly adds some longer timeouts to the connection string.

    if the app then runs a query that is long running, the application throws it's hands up after thirty seconds and returns an error, even though SQL server is still working on returning the results/finishing the desired query.

    you could check the DMV's for long running queries, but it would be better to throw this in the lap of the applications team and tell them they are timing out ; have the original user report what exactly they were running that took a long time.

    this might help find some of your slower queries:

    select

    fn.*,

    st.*

    from sys.dm_exec_query_stats st

    cross apply sys.dm_exec_sql_text(st.[sql_handle]) fn

    where st.max_elapsed_time >= (1000 * 15) --15 seconds

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • June 25, 2013 at 1:31 pm

    #1627284

    It also could happen as a result of blockings. Check if application's S.P. are blocked during their execution.

  • June 25, 2013 at 1:36 pm

    #1627288

    Could be due to locking . You can monitor this with profiler .

  • June 25, 2013 at 4:18 pm

    #1627338

    Thank you very much ..

    Regards,
    Shivrudra W

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply