I have a poorly written application running a SELECT *, resulting in a 2MB result set every few seconds. I cannot correct this. I am confused though,by the connection encountering ASYNC_NETWORK_IO waits. The application is local to the database server.
I have verified the session_id in dm_exec_connections is 'Shared memory'. The client_net_address is 'local machine'.
Anyone ever experienced this before? Or able to explain to me why this is happening?