Suspended session

  • IMary

    Old Hand

    Points: 356

    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 3 weeks, 5 days ago by  IMary.
    • This topic was modified 3 weeks, 5 days ago by  IMary.
  • Sreekanth B

    SSCertifiable

    Points: 6144

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

  • IMary

    Old Hand

    Points: 356

    No, query takes <1 sec from SSMS

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

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