Optimize database performance
Intermediate
Database Administrator
Developer
Data Engineer
Azure
Azure SQL Database
SQL Server
Optimize Azure SQL Database performance by choosing the right service tier and managing concurrency with transaction isolation levels. Analyze queries with execution plans and DMVs. Use Query Store for plan management and diagnose blocking and deadlocks.
Learning objectives
By the end of this module, you're able to:
- Evaluate and recommend database configurations including service tiers, compute tiers, and resource limits.
- Choose transaction isolation levels and concurrency controls that balance consistency with throughput.
- Analyze query performance using execution plans and dynamic management views.
- Monitor and tune queries with Query Store and Query Performance Insight.
- Identify and resolve blocking and deadlocks using DMVs and Extended Events.
Prerequisites
- Basic understanding of SQL and Transact-SQL.
- Familiarity with Azure SQL Database or SQL Server.
- Experience creating and configuring resources using the Azure portal.
Get started with Azure
Choose the Azure account that's right for you. Pay as you go or try Azure free for up to 30 days. Sign up.