Configure databases for optimal performance
Implement tasks for both IaaS and PaaS to maintain indexes, and statistics. Explore the automatic tuning features of Azure SQL Database. Control database-level configuration options. Explore Intelligent Query Processing.
Learning objectives
After completing this module, you will be able to:
- Understand database scoped configuration options
- Understand maintenance tasks related to indexing and statistics
- Understand the features of Intelligent Query Processing (IQP)
- Explore the automatic tuning feature in Azure
Prerequisites
- Ability to write code in the SQL language, particularly the Microsoft T-SQL dialect, at a basic level.
- Experience creating and configuring resources using the Azure portal.
- Basic understanding of structure and usage of SQL Server indexes.