Banov
Banov

Reputation: 297

ASP.NET MVC website performance issue on Azure AppServices

We have a ASP.NET MVC5 website hosted on Azure AppServices.

We have 2 distinct instances of this site on Azure: 1 for tests and 1 for production.

This 2 instances are in distinct Azure plans, but all services considered in each instance is in the same region (Western Europe).

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).

Each of our application instance is composed of:

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.

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).

The Sql requests respond times are also separately ok (under 300ms).

We have, of course, already read a lot of posts about Azure performance issues but nothing that has helped us.

We would really appreciate some help please. Many thanks!

Upvotes: 0

Views: 253

Answers (1)

evilSnobu
evilSnobu

Reputation: 26314

Enable the profiler in Application Insights (same thing that used to live under https://azureserviceprofiler.com). It's now under the Performance blade.

Stress test your application for a few hours, enough for a good amount of ETL traces to be collected so it can paint a comprehensive picture of where time is being spent. A tiny "trace" icon will then become available next to your controllers:

Profiler

Results look like this:

traces

Upvotes: 1

Related Questions