Umbraco admin panel slowdown with azure basic database plan and website performs too slow

1
votes

I am using Umbraco v7.8.1

I am not bale to fix the slowdown problem with azure basic database plan, website performs too slow.

In my development environment I am using local database server, to setup my website and then I have restored it to azure database to go live.

And I found that Umbraco admin panel is working too slow than development environment.

So I have change Resource Configuration for live database ( from Basic to Standard with 50 DTU and 2 GB memory)

But still azure database performance is too slow.

I have also refer below links, but failed to fix problem.

Running Umbraco on Azure Web Apps

Tuning performance in Azure SQL Database

Please help me to fix this problem

1
c#azure-sql-databaseumbracoumbraco7
When you perform a "save" in the backoffice does the database actually use 100% DTU? We had a similar issue and it was actually the location of the XML cache and not the database at all. – Jason Elkin

1 Answers

1
votes

A Standard Azure SQL database with 50 DTU is also known as the S2 tier. Taken from the Best practices chapter of the document you linked to (Running Umbraco on Azure Web Apps):

The minimum recommended Azure SQL Tier is "S2", however noticeable performance improvements are seen in higher Tiers.

So it's probably relatively easy to improve your performance by upping your Azure SQL Database tier.