Microsoft · DP-800
Plans, DMVs, and Query Store
DP-800 · Lesson 12 of 20 · 1:26: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-800 exam (Microsoft Certified: SQL AI Developer Associate). In this lesson: estimated and actual execution plans and their warnings, dynamic management views for expensive and running queries, Query Store with regressed queries, forced plans, and hints, and Query Performance Insight. Includes three original practice questions.
Preview the topics
- An actual plan shows an index scan on Orders, with an implicit conversion warning: the procedure passes an nvarchar parameter, while OrderCode is a varchar column. What is the best fix?
- After Tuesday’s deployment, the order history statement switched to a slower plan, and Query Store still holds the fast one. The code cannot change before next week. What restores performance now?
- Query Performance Insight has shown no new data since Monday, and the Query Store options view reports an actual state of READ_ONLY, while the desired state is READ_WRITE. What should the team do?