Episode

Configuring and Maintaining Azure SQL for Performance (35 of 61)

In this video, learn how Azure SQL Database and Azure SQL Managed Instance can be configured and maintained for performance.

For the full Azure SQL Fundamentals learning path on Microsoft Learn, visit: https://aka.ms/azuresqlfundamentalsyt

Watch the entire series: https://aka.ms/azuresql4beginnersch9
View code on Github: https://aka.ms/asqlworkshop, select Workshop: Azure SQL
Learn live: https://aka.ms/azuresqlbootcamp

[00:45] Tempdb
[02:03] Database
[02:36] Files & filegroups
[03:31] Max degree of parallelism (MAXOP)
[04:07] Resource governor
[04:35] Maintaining for performance