Timeline for Can Query Store Show Spills To Tempdb?
Current License: CC BY-SA 4.0
14 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Feb 18 at 1:02 | comment | added | Mitch Wheat | @J.Mini : usually when one is looking at TempDb spills, its related about something that is happening now or very recently, not a month ago. | |
| Feb 17 at 16:19 | vote | accept | J. Mini | ||
| Feb 17 at 15:57 | answer | added | Erik Reasonable Rates Darling | timeline score: 5 | |
| Feb 17 at 15:01 | comment | added | J.D. |
FWIW, sp_blitzcache also (in your own words) "has nothing to do with query store". If you're satisfied with it, then you should be equally satisfied with what Mitch presented you.
|
|
| Feb 17 at 14:43 | comment | added | J. Mini | @MitchWheat Because Query Store contains far more long-lasting information than the plan cache. | |
| Feb 17 at 14:35 | comment | added | Mitch Wheat | It hasn't. why do you care where the info comes from? AFAIK it is not available from QS currently. | |
| Feb 17 at 14:20 | comment | added | J. Mini | @MitchWheat That's helpful, but I'm pretty sure that's got nothing to do with Query Store. | |
| Feb 17 at 14:19 | history | edited | J. Mini |
edited tags
|
|
| Feb 17 at 10:29 | history | migrated | from stackoverflow.com (revisions) | ||
| Feb 17 at 9:37 | comment | added | Martin Smith |
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
|
|
| Feb 17 at 4:33 | comment | added | Mitch Wheat | sys.dm_exec_query_stats contains spill stats SQL Server 2017 CU3 + : learn.microsoft.com/en-us/sql/relational-databases/… | |
| Feb 17 at 1:06 | comment | added | J. Mini | @nbk sp_blitzcache reports on it. | |
| Feb 17 at 1:05 | comment | added | nbk | why are you confident? | |
| Feb 17 at 1:01 | history | asked | J. Mini | CC BY-SA 4.0 |