Microsoft · DP-300
Monitoring activity and performance
DP-300 · Lesson 11 of 22 · 1:36:43
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: building an operational baseline, Azure Monitor metrics and dynamic management views, Query Performance Insight and diagnostic settings, database watcher (in preview) with KQL, and Extended Events sessions and targets. Includes three original practice questions.
Preview the topics
- Contoso’s prescriptions database shows a log write percentage near 100 at the same time each night, while CPU stays low. What does that suggest?
- Contoso wants to capture every statement longer than two seconds on one Azure SQL database, and keep the events for analysis next week. What should it create?
- Contoso’s DBAs manage sixty databases and twelve managed instances, and want one place with detailed performance data from all of them, queryable with KQL, without agents. What fits?