- Module 1: Describe performance monitoring
- Review potential performance issues.
- Identify critical Azure metrics.
- Learn how to collect metrics for an established baseline.
- Use extended events for performance analysis.
- Understand Azure SQL Database Intelligent Insights.
- Module 2: Explore causes of performance issues
- Understand the purpose and benefits of the Query Store
- Investigate the available reports and data in the Query Store
- Observe the impact of forcing execution plan selection
- Learn how blocking and locking work in the SQL Server database engine
- Learn about database isolation levels
- Gain understanding of database fragmentation and its impact
- Module 3: Configure SQL Server resources for optimal performance
- Understand your options for configuration of Azure storage
- Learn how to configure TempDB data files in SQL Server
- Learn how to choose the right type of VM for SQL Server workloads
- Understand the use cases and configuration of Resource Governor in SQL Server
- Module 4: Control database-level configuration options. Explore Intelligent Query Processing. Configure Open Source databases for optimum performance.
- Configure Database Scoped Configuration Options
- Understand the features of Intelligent Query Processing
- Explore performance monitoring options in Azure Database for PostgreSQL and MySQL
- Module 5: Describe performance-related maintenance tasks in SQL Server
- Implement maintenance tasks for indexing and statistics
- Gain insight on plan forcing
- Explore the auto-tuning feature in Azure
After completing this module, you will be able to:
After completing this module, you will be able to:
After completing this module, you will be able to:
After completing this module, you will be able to:
After completing this module, you will be able to: