Post reply

Suspended process

  • March 11, 2010 at 6:16 am

    #221712

    Hi All,

    while monitoring process on sql server on production db , i am getting waits with type ASYNC_NETWORK_IO and status suspended.

    After more monitoring i found that this wait is associated with a specific heavy view.

    i ran same view on my local db to test whats happening exactly, my application ran the view and it came back with result and finished loading data but the strange thing is that when i check process i found it waiting with same type and status as above!!!!, although it finished execution.

    Pls tell me why is it waiting like that and if there is anyway to fix this if its a problem in the first place.

    Thanks in advance

    Best Regards

    Nader

  • March 11, 2010 at 7:30 am

    #1132029

    The wait state suggests that your process is waiting either on traffic on the network or the client software is not taking the results quickly enough.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

  • March 11, 2010 at 7:34 am

    #1132034

    Thanks for ur reply

    The thing i am confused about is that application has finished loading data already and function using this SQL has finished execution , why is the process showing as waiting with this wait type.

    Note:the screen that loaded data is still open but not doing anything, once i close it the process is killed and the wait doesnt show.

    regards

    Nader

  • March 11, 2010 at 7:47 am

    #1132048

    It sounds like, possibly, the app is holding the transaction open. If you close the window the connection and the wait clears... pretty good indicator.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

  • March 13, 2010 at 11:58 am

    #1133247

    I am sorry for the late reply my windows crashed and i had to reinistall everything :(.

    i ran dbcc opentran and nothing came up , anything else to check or try.

    Thanks

  • March 13, 2010 at 6:56 pm

    #1133275

    nadersam (3/11/2010)

    Thanks for ur reply

    The thing i am confused about is that application has finished loading data already and function using this SQL has finished execution , why is the process showing as waiting with this wait type.

    Note:the screen that loaded data is still open but not doing anything, once i close it the process is killed and the wait doesnt show.

    regards

    Nader

    Check with your network team, if there is any issues with network waits, may be there was network clinch at that time.

    EnjoY!

  • March 13, 2010 at 7:04 pm

    #1133276

    nadersam (3/13/2010)

    I am sorry for the late reply my windows crashed and i had to reinistall everything :(.

    i ran dbcc opentran and nothing came up , anything else to check or try.

    Thanks

    Please post new questions in different post.

    There is no need to run DBCC opentran if it is power or windows failure. For this question run DBCC CheckDB on all databases.

    EnjoY!

  • March 14, 2010 at 12:24 am

    #1133339

    Thanks for all replies

  • March 14, 2010 at 12:44 am

    #1133343

    nadersam (3/14/2010)

    Thanks for all replies

    You are welcome.

    EnjoY!

Viewing 9 posts - 1 through 8 (of 8 total)

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