Reduce Cost by Tuning Queries on Azure DBaaS
Poorly written queries on on-premise servers slow down the server performance.
But in the case of Azure SQL database, those queries not only degrade the application performance but also cost money. When you tune queries in Azure SQL Database, you may benefit from reducing resource demands as your application might run at a lower compute size and then eventually you can reduce cost.
In any given SQL Server instance, there are likely 8 to 10 queries or stored procedures that are responsible for 80 to 90 percent of the server load. If you can identify these problem queries and tune them, you can make a significant impact on the overall performance of your database. This presentation will explain some simple techniques of tuning the queries and will demonstrate before and after performance differences.
Read The Presentation Here