Post reply

Suspended session

  • November 19, 2019 at 5:26 pm

    #3698915

    Hi,

    Application service is going to hung state and when we check the database, there is a connection in suspended state and it is running forever until we restart the service. And the wait event is ASYNC_NETWORK_IO. The query running is very small select query, fetching couple of hundred rows.

    and there is no information in application logs or DB logs. Can you please advise what will be happening here? what can be checked?

    • This topic was modified 4 years, 5 months ago by  IMary.
    • This topic was modified 4 years, 5 months ago by  IMary.

  • November 19, 2019 at 6:27 pm

    #3698932

    Does the same query take forever if you run it from SSMS locally?

  • December 9, 2019 at 5:55 pm

    #3706065

    No, query takes <1 sec from SSMS

Viewing 3 posts - 1 through 2 (of 2 total)

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