Query Store in 2016

  • Comments posted to this topic are about the item Query Store in 2016

    _______________________________________________________________
    To get quick answer follow this link:
    http://www.sqlservercentral.com/articles/Best+Practices/61537/

  • This was removed by the editor as SPAM

  • Didn't know about this, but that's a sweet new feature!

    Cheers Kapil.

  • Without knowing the answer or what the query store is, this question is guessable with a solid understanding of the system databases. But, it got me to thinking. It makes sense for this feature to not be available for the tempdb. It makes sense to have the ability to enable it in the model database to provide the ability to have it enabled for all newly created databases. The quandary is what will happen if you enable on the model database, then stop SQL and delete the tempdb files. When SQL creates the tempdb from the model database, will it succeed, or will it fail and stop SQL?

  • Question is not formed well.

    The Query Store feature is not enabled for which databases?

    - It's not enabled for all user databases by default. And you cannot enable the query store for the master or tempdb database.

    Igor Micev,
    My blog: www.igormicev.com

  • Igor is right. I had to read author's mind. However, the concept is interesting.

    Thanks, Kapil!

  • Igor Micev (7/30/2015)


    Question is not formed well.

    The Query Store feature is not enabled for which databases?

    - It's not enabled for all user databases by default. And you cannot enable the query store for the master or tempdb database.

    +1

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • SQLRNNR (7/30/2015)


    Igor Micev (7/30/2015)


    Question is not formed well.

    The Query Store feature is not enabled for which databases?

    - It's not enabled for all user databases by default. And you cannot enable the query store for the master or tempdb database.

    +1

    + 1



    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • Quite straight forward. Scored 1 mark.

    Thanks.

  • Thanks for the nice question.

  • Great question, thanks.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

Viewing 11 posts - 1 through 11 (of 11 total)

You must be logged in to reply to this topic. Login to reply