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

Bugbash: Enable Query Store for tempdb

ALTER DATABASE tempdb SET QUERY_STORE = ON;

Query Data Store cannot currently be enabled on tempdb

Msg 12438, Level 16, State 1, Line 1
Cannot perform action because Query Store cannot be enabled on system database tempdb.
Msg 5069, Level 16, State 1, Line 1
ALTER DATABASE statement failed.

6 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

    AdminMicrosoft SQL Server (Admin, Microsoft Azure) shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

    Upvotes: 198

    <=-=Nov 3 2015 10:21AM=-=>

    And not just for sandboxing…on production servers where we have special crazy-fast multi-TB cache cards for the TempDB but the SAN where the production databases reside is relatively slow. This makes it very compelling to force a lot of things to happen inside TempDB and then later sync that to production.

    <=-=Apr 2 2017 8:08AM=-=>

    Thank you for taking time to post this issue! We understand that this could be an important issue for you.

    This item is high on our priory list, but unfortunately, we do not plan to include a fix for this issue in the upcoming release. Although, we might include it as an improvement in future releases.

    <=-=Apr 2 2017 8:08AM=-=>

    Thank you for taking time to post this issue! We understand that this could be an important issue for you.

    This item is high on our priory list, but unfortunately, we do not plan to include a fix for this issue in the upcoming release. Although, we might include it as an improvement in future releases.

    0 comments

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

      Feedback and Knowledge Base