I have a web app that queries a database. When a certain function of the site is accessed, the user is experiencing 30-45 seconds of timeout before data is displayed from the database. I have the WhoIsActive stored procedure on the DB. When I execute the stored procedure while the website is timing out, I see the ASYNC_NETWORK_IO wait.
If I take the exact query that is being executed, and run it directly on the DB server, the query executes in 1-2 seconds.
The app and DB server is hosted at a 3rd party provider, but I brought the DB to a local dev box and am not seeing the see results. The data is displaying on the website in 2-3 seconds as expected.
What can I check on either the app or db server as this appears to be network related?
Any help is greatly appreciated.