I have an Azure Web App which runs a MVC 5 applications. The database for this applications is Azure SQL database.
This application is still in it's beginnings, so it has virtually no traffic and very few items in the database. Even so, there are a lot of times when the web application is slow to respond. Sometimes a request which only makes a single DB query takes 4-5 seconds (maybe more).
As I use the applications it's gets faster; the requests eventually take under 100ms. But then, for unknown reason, it starts being slow again. It doesn't follow an exact pattern.
I have set "AlwaysOn = true" on the Web Apps, but I don't see that big of an improvement.
Is there something that can be done or is there something that I'm missing?