🔥 3-day streak
Microsoft Azure Database Administrator Associate91 / 144
Question 91 of 144
You administer an Azure SQL Database supporting a reporting workload. A specific stored procedure intermittently runs slowly. You suspect the query is spilling large sort and hash operations to tempdb during the slow executions. Before changing indexes or memory grants, you want to confirm the spill behavior by examining actual runtime metrics captured per execution plan. Which Query Store view or metric should you examine to confirm tempdb spilling for this query?
Reviewed for accuracy · Report an issueNext question