Microsoft · DP-300
Configuring for scale and performance
DP-300 · Lesson 3 of 22 · 20:21
YouTube loads only after you press play. This chapter opens at its timestamp in the full course. Watch on YouTube ↗
In this lesson
Prepare for the DP-300 exam (Administering Microsoft Azure SQL Solutions). In this lesson: scaling Azure SQL Database by compute size, tier, and hardware, read scale-out and elastic pool limits, scaling Managed Instance and the Next-gen General Purpose tier, and SQL Server on Azure virtual machines: memory optimized sizes, tempdb, instant file initialization, separate data, log, and tempdb drives, host caching, and Premium SSD v2. Includes three original practice questions.
Preview the topics
- Contoso’s nightly reports run against the Business Critical prescriptions database and slow down live orders. The team wants to move them off the primary replica, without paying for another database. What should it do?
- Contoso’s SQL Server VM runs on a general purpose size with two vCores, and memory pressure slows its queries. Which change follows the best practices?
- Contoso’s VM keeps its data and log files on one disk with read-write caching, and writes are slow. Which configuration should the team apply?