Overview
Discover effective techniques for optimizing query performance and reducing costs in Azure SQL Database in this informative conference talk from PASS Data Community Summit. Learn how poorly written queries not only impact server performance but also increase expenses in cloud-based environments. Explore simple yet powerful query tuning methods that can significantly improve overall database performance and potentially lower compute requirements. Gain insights into identifying and optimizing the top 8-10 queries responsible for the majority of server load. Watch a demonstration comparing query performance before and after tuning, and understand how these optimizations can lead to substantial cost savings in Azure DBaaS environments.
Syllabus
Reduce Cost by Tuning Queries on Azure DBaaS - Rajnikant Tandel
Taught by
PASS Data Community Summit