November 19, 2019 at 5:26 pm
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?
November 19, 2019 at 6:27 pm
Does the same query take forever if you run it from SSMS locally?
December 9, 2019 at 5:55 pm
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