Our web application is suddenly experiencing intermittently slow performance (slow page loads, slow ajax calls going from <1 sec to over 20 secs). The only clue is when the application slows, we see ASYNC_NETWORK_IO waits being reported by the MS SQL server. These errors, and the slowdown occurs under both heavy and light server loading (as determined by the number of connections).
This application has been in place for several months without problems, the only recent changes Azure-wise being the addition of auto-scaling and SQL server fallback a few months ago. The application itself is under routine development and deployments.
We have looked at the code to see if any recent coding changes could have affected the performance from an application --> SQL standpoint, but can't find anything (all database calls go through a NetTiers DAL).
Summary: MVC 4 application Azure deployment, multi-tenant with autoscale MS SQL Server, with fallback Azure Storage NetTiers DAL.
Any ideas on the intermittent performance issue would be appreciated.