Azure SQL Database - Lessons Learned from the Trenches

Dive into a comprehensive conference talk from PASS Data Community Summit on Azure SQL Database best practices and performance optimization. Learn from Microsoft CSS support cases and customer engagements as Jose Manuel Jurado Diaz shares valuable insights on monitoring and improving query performance. Explore the effective use of Query Store, Extended Events, and DMVs to enhance database response times in the Microsoft Azure cloud. Gain practical knowledge through multiple demonstrations covering topics such as CPU performance, serverless configurations, troubleshooting techniques, and connection management. Discover essential lessons learned from real-world scenarios to successfully implement and maintain Azure SQL Databases in production environments.

Introduction
Who are you
Agenda
Background Check
Performance Issues
CPU Performance
Management Studio
Diagnostic Settings
Lessons Learned
Serverless
Review your code
Troubleshooting
Running extended events
Opening previous capture
Managing Azure SQL Database
Download Azure SQL Database
Client closed connection
USB timeout
USB aborted
Command timeout
More questions
Which one do you prefer
Whats running
Event Profiler
What we learned
The issue
Profiler
Connection Times
How Did We Fix That
Whats The Issue
My Role
Every Time
Connection Time
Replication Time
Connection Pooling
The Developer
What were the lessons learned
How connections work