Microsoft · DP-300
Server and database configuration
DP-300 · Lesson 15 of 22 · 2:06:50
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: server settings for performance (MAXDOP, cost threshold for parallelism, max server memory, optimize for ad hoc workloads, tempdb files), Resource Governor, database scoped configuration, and scaling when settings are not enough. Includes three original practice questions.
Preview the topics
- On Contoso’s Managed Instance, a reporting application, identified by its application name, must never use more than 30% of the CPU, while the pharmacy app keeps the rest. What should the DBA configure?
- After moving to compatibility level 160, one Contoso database gets worse plans from the new cardinality estimator, while the other IQP features help. What keeps the new level, and the old estimator?
- Contoso’s Azure SQL database reaches its maximum data size on General Purpose, while CPU and IO are fine. What should the DBA do?