We have moved our SQL Server from Azure VM to the Azure SQL database. Azure VM had DS2_V2, 2 cores, 7 GB of RAM, 6400 max. IOPS Azure SQL Database - Standard S3, 100 DTU. I chose this level after running the Azure DTU Calculator tool on the Azure VM for 24 hours - it offered this level for me.
The problem is that queries (mainly SELECT and UPDATE) are now very slow compared to how they were on Azure VM. One thing I noticed is that during the execution of the request, I switched to the resource usage schedule in the "Monitoring on the Azure portal" section, and it pinged 100% during the execution of any request. Does this mean that my level is actually too low? Hopefully not because the next level is a pretty big leap in value.
For information only, the Azure SQL database is identical in design to the data for the Azure VM database, and after migration I rebuilt all the indexes (including Full-Text).
In my research so far, I have read everything to make sure that my Azure SQL DB is in the correct region on Azure (is) with network latency (nonexistent on Azure VM), which causes a problem.
source share