title: ASP.NET MVC website performance issue on Azure AppServices
body: <p>We have a ASP.NET MVC5 website hosted on Azure AppServices.</p>
  
  <p>We have 2 distinct instances of this site on Azure: 1 for tests and 1 for production.</p>
  
  <p>This 2 instances are in distinct Azure plans, but all services considered in each instance is in the same region (Western Europe).</p>
  
  <p>The first one seems to work in an acceptable manner, but we are facing performance issues loading some pages on the 2nd one (sometimes from 15s to +30s page load times).</p>
  
  <p>Each of our application instance is composed of:</p>
  
  <ul>
  <li>ASP.NET MVC 5 (with FormsAuthentication)</li>
  <li>N-Tiers Architecture</li>
  <li>EntityFramework 6.1.3</li>
  <li>ApplicationInsights service</li>
  <li>2 SqlServer Databases (1 for business data &amp; 1 for security data) located in a Azure Sql Service</li>
  </ul>
  
  <p>The Azure plan used is "Basic (Small)" for AppServices, and "S0 Standard (10 DTUs)" for SqlServices.
  The 1st one is running around 5% for CPU and 58% for Memory. The 2nd one is running around 3% for DTU.</p>
  
  <p>With AppInsights, I've seen that "all is ok in controller" and the problem might comes from below. 
  I've also detected some page loads having the issue presents a failed Sql dependency call (with result code 207).</p>
  
  <p>The Sql requests respond times are also separately ok (under 300ms).</p>
  
  <p>We have, of course, already read a lot of posts about Azure performance issues but nothing that has helped us.</p>
  
  <p>We would really appreciate some help please.
  Many thanks!</p>