Fixing Poor Performance Patterns in Azure SQL Database Applications

Discover strategies for optimizing Azure SQL Database application performance in this 58-minute conference talk. Learn how cloud databases differ from on-premises solutions and explore common performance-impacting patterns. Gain insights into design and planning steps, along with tools for identifying hidden issues to improve application performance. Explore topics such as latency considerations, firewall access, over-fetching, memory optimization, compression, resource limits, and performance analysis. Acquire practical knowledge to address potential performance bottlenecks and bring your cloud database application closer to on-premises performance levels.

Introduction
Onpremises vs Cloud
Overview
Firewall Access
Considerations
Simple Client Demo
Over fetching
Memory optimization
Memory consumption comparison
Compression
Estimates
Resource Limits
Performance Analysis