Question 720
Service calls time out while CPU remains low and many sessions wait on locks. The team implemented this change: Find and correct the blocking transaction or query with approved procedures. Which result would best confirm the change worked?
Explanation
Correct Answer
Wait chains clear and transaction latency stabilizes. DMVs can expose blocking sessions, wait types and transaction states.
Incorrect Answers
That observation could pass while the problem persists: Blocking is about lock ownership and transaction lifetime; inspect DMVs/wait chains before changes.
This acceptance test measures the wrong outcome: Use request/transaction DMVs and waiting-resource evidence; termination may trigger lengthy rollback.
The suggested success signal is inadequate because Execution-plan analysis can complement lock investigation but does not substitute for live wait and blocker evidence. The suggested measurement would appear successful even in a reproducible case where the original failure remains.