Episode

DP-300 Configure SQL Server resources and databases for optimal performance (11 of 18)

with Neil McIssac

Choose the appropriate size and storage options for your Azure SQL databases. Configure server resources such as tempdb. Understand the usage of Resource Governor. 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.

Intermediate
Data Analyst
Azure