Do you have a comment or suggestion to improve SQL Server? We’d love to hear it!

Add Query Store to Model for Auto Configuration on New Databases

Add Query Store Configuration to Model Database, so new databases created will automatically have Query Store enabled.

5 votes
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Phil Ekins shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

    1 comment

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      Signed in as (Sign out)
      Submitting...
      • Andy Mallon commented  ·   ·  Flag as inappropriate

        While the GUI doesn't allow you to do this, you can use TSQL to add Query Store configurations to model. If you do that, it will not enable Query Store on the model database, but rather will ensure that all newly created databases are created with Query Store enabled.

      Feedback and Knowledge Base