HiveBrain v1.2.0
Get Started
← Back to all entries
patternsqlMinor

SQL Server Query Store on isolated volume

Submitted by: @import:stackexchange-dba··
0
Viewed 0 times
sqlquerystoreservervolumeisolated

Problem

Is there a way to isolate Query Store data to a separate volume? I have a thousand or so databases that we’ve gotten pretty good at predicting growth for. I’m unsure of how much storage Query Store will need, but to be valuable across various scheduled workflows, I need 30 days. I know I can specify storage limits for QS, but wondering if I can just add a large volume of cheaper storage and dump Query Store there?

Solution

No, as of 2018/04/25, you can't choose the filegroup where Query Store data is placed. In the databases where you enable Query Store, the data goes into the default filegroup.

It was a highly upvoted Connect item, so other folks share your pain - so I would expect that to be an enhancement added in the future.

Thanks to @klitzkrieg, here are the current feedback items:

  • Option to store query store data in a filegroup other than PRIMARY



  • Create central repository for Query Store

Context

StackExchange Database Administrators Q#204939, answer score: 3

Revisions (0)

No revisions yet.