This course focuses on optimizing Azure SQL Database performance and availability for mission-critical applications. By reviewing best practices, participants will learn how to select the right database configuration, leverage Azure SQL Database ecosystem advantages, and optimize performance in the cloud. The course covers factors to consider when migrating legacy applications, application patterns, anti-patterns, and various tools for performance tuning. The teaching method includes a session recording from PASS Summit 2019, with a syllabus covering topics such as data loading, connectivity architecture, best practices, and troubleshooting. The intended audience for this course includes database administrators, cloud architects, and IT professionals looking to enhance their skills in maximizing Azure SQL Database performance and availability.
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
