Microsoft · DP-300
Query Store, DMVs, and blocking
DP-300 · Lesson 12 of 22 · 1:44:36
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: Query Store and its settings, finding regressions, forcing plans, and Query Store hints, the dynamic management views for requests, query statistics, and waits, finding the head blocker of a blocking chain, and preventing blocking and deadlocks with short transactions, good indexes, and read committed snapshot. Includes three original practice questions.
Preview the topics
- After a statistics update, Contoso’s daily report takes forty seconds instead of one. Query Store shows two plans, and the old one was fast. What’s the quickest fix that needs no code change?
- Contoso’s DBA needs the ten statements that used the most CPU since their plans were cached, with their text. Which views should the query join?
- Contoso’s order screen freezes. Thirty requests are waiting, many with blocking_session_id = 57; session 57 is not blocked, and sleeps with an open transaction. What should the DBA do first?