Skip to main content

You are not logged in. Your edit will be placed in a queue until it is peer reviewed.

We welcome edits that make the post easier to understand and more valuable for readers. Because community members review edits, please try to make the post substantially better than how you found it, for example, by fixing grammar or adding additional resources and hyperlinks.

Required fields*

9
  • why are you confident? Commented Feb 17, 2024 at 1:05
  • @nbk sp_blitzcache reports on it. Commented Feb 17, 2024 at 1:06
  • sys.dm_exec_query_stats contains spill stats SQL Server 2017 CU3 + : learn.microsoft.com/en-us/sql/relational-databases/… Commented Feb 17, 2024 at 4:33
  • If it was going to store that aggregated information it would be in sys.query_store_runtime_stats - and no such columns there - so looks like not persisted to query store Commented Feb 17, 2024 at 9:37
  • @MitchWheat That's helpful, but I'm pretty sure that's got nothing to do with Query Store. Commented Feb 17, 2024 at 14:20