I know that Query Store can show tempdb usage as of SQL Server 2017, but can it show spills to tempdb? I'm highly confident that the plan cache can.
Can Query Store Show Spills To Tempdb?
J. Mini
- 851
- 7
- 23