Hello guys,
I have an issue with recently deployed App Service with Azure SQL database underneath. I have the application deployed on two different tenants.
On one tenant the application loads very fast and all the initial queries are running smoothly, on the other one - first load is slow as hell .
Trying to find a root cause, I created simple app with one piece of code opening connection to the SQL server and running one simple query:
SELECT COUNT(*) FROM [User] WHERE Id = 10
Again, after deployment I can see the same behavior - on one of the tenants initial load takes 15 sec (and all of this time is taken by SQL code) all subsequent calls are running smoothly. Other tenant runs without any problems.
When I close the browser, wait some time and I come back to the application in the next session - it looks exactly the same. First call - around 15 seconds, then when I refresh it works fine.
Do you have any idea where to start looking?
Regards
Tomasz
