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.
Fixing Poor Performance Patterns in Azure SQL Database Applications
Overview
Syllabus
Introduction
Onpremises vs Cloud
Overview
Firewall Access
Considerations
Simple Client Demo
Over fetching
Memory optimization
Memory consumption comparison
Compression
Estimates
Resource Limits
Performance Analysis
Taught by
NDC Conferences
