Monitor and optimize operational resources in Azure SQL

After completing this module, you will be able to:

• 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.

After completing this module, you will be able to:

• 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

After completing this module, you will be able to:

• 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

After completing this module, you will be able to:

• Configure Database Scoped Configuration Options
• Understand the features of Intelligent Query Processing
• Explore performance monitoring options in Azure Database for PostgreSQL and MySQL

After completing this module, you will be able to:

• Implement maintenance tasks for indexing and statistics
• Gain insight on plan forcing
• Explore the auto-tuning feature in Azure

• Introduction
• Describe performance monitoring tools
• Describe critical performance metrics
• Establish baseline metrics
• Explore extended events
• Describe Azure Intelligent Insights
• Exercise: Isolate problems with monitoring
• Knowledge check
• Summary

• Introduction
• Describe SQL Server Query Store
• Describe blocking and locking in SQL Server
• Describe data file fragmentation
• Exercise: Identify and resolve blocking issues
• Knowledge check
• Summary

• Introduction
• Explain how to optimize Azure storage for SQL Server virtual machines
• Describe virtual machine resizing
• Optimize database storage
• Control SQL Server resources
• Knowledge check
• Summary

• Introduction
• Describe database scoped configuration options
• Describe intelligent query processing
• Describe query store in Azure Database for MySQL and PostgreSQL
• Knowledge check
• Summary

• Introduction
• Maintain indexes
• Maintain statistics
• Describe automatic tuning
• Exercise: Detect and correct fragmentation issues
• Knowledge check
• Summary