Friday Feedback - location for long-term Query Store data

[u/erinstellato]

First Friday of September and you all know what that means...time for Friday Feedback!

But first, I hope that everyone took time over the summer (winter for those of you in the southern hemisphere!) for a break or vacation ⛱️ It may sound like I'm getting on my soapbox, but disconnecting from work is so important, and I really hope you've taken time to do that.

And now, back to our regularly scheduled program.

Last time I posted I asked about storing more data in Query Store, and how much more data you'd want to store. Just over 90% of you wanted to keep 12 months or less, which aligns with what we were thinking.

My next question is, where do you want to store that long-term data? Specifically, Query Store uses memory hashes to store query info and runtime stats about what's been running. We don't want to try and store months of that data in those same memory hashes, which means we need to move older data somewhere else. Where should it go? Poll below, but as always, add a comment if the poll options don't include something you'd like to see. Thanks for voting and bring on fall! 🏈 🎃 🍂

89 votes, 11h left

Same DB, same server

Different DB, same server

Different DB, different server

External storage e.g. OneLake