title: Azure App Service to Azure SQL very high latency
body: <p>I have a Asp.Net Core app talking to an Azure SQL database which is in the SouthCentral US. When I run the app locally (from Wisconsin) and point to the Azure SQL in SouthCentral US, the app responds in approximately 2 seconds (SQL query is a little complex with table valued parameter, cross apply and a CTEs). So I'm ok with 2 second response time.</p>
  
  <p>When I deploy this app to an Azure App Service in SouthCentral US (Same as DB), it takes minimum of 15 seconds to respond.</p>
  
  <p>Looking at the application insights, the app says the SQL dependency took 600ms. When I added log statements before and after the SQL call, I see the logs are being emitted at least 14 seconds apart from each other.</p>
  
  <p>So far I've tried the obvious things. Moving app and DB to same region. Changing the App Service Plan (sizes tried: S1, S2, P2V2, B3). Scaled the database from standard 10 - 100 DTUs. Even tried deleting the resource group and re-deploying every time I changed the app service plan size, instead of using the 'Scale Up' feature. Nothing seems to be helping.</p>
  
  <p>Any other thoughts on troubleshooting this issue?</p>