Explore best practices for optimizing Azure SQL Database performance and availability in this comprehensive conference talk from PASS Data Community Summit. Learn how to select the ideal Azure SQL database configuration for specific application patterns, balancing cost, performance demands, and availability requirements. Discover strategies for achieving high availability (99.995% uptime) and maximizing performance for mission-critical applications. Gain insights into leveraging Azure SQL Database ecosystem advantages, optimizing cloud performance, and addressing application patterns and anti-patterns when migrating legacy applications from SQL Server. Delve into topics such as purchasing options, performance tuning techniques, Azure SQL Database tools, data loading tips, connectivity architecture, and troubleshooting methods. Watch a demo featuring Managed Instance and explore concepts like memory grants and log rate governance to enhance your Azure SQL Database implementation.
Azure SQL Database - Maximizing Cloud Performance and Availability
PASS Data Community Summit via YouTube
Overview
Syllabus
Introduction
Agenda
Why are customers coming
Purchasing options
Performance tuning discussion
Azure SQL Database performance tuning
Azure SQL Database tools
Demo
Data Loading
Log Rate Governance
Other Data Loading Tips
Connectivity Architecture
Other Best Practices
SQL Server IP Port
Demo with Managed Instance
Troubleshooting
Memory Grants
Taught by
PASS Data Community Summit
