Query Store in 2016

Question

Post reply

Query Store in 2016

kapil_kk

SSC-Insane

Points: 21316
More actions
July 29, 2015 at 11:19 pm

#299277

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/
July 30, 2015 at 12:54 am

This was removed by the editor as SPAM

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

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

Gazareth One Orange Chip Points: 27737 More actions · Answer 1

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

Cheers Kapil.

Robert Eder SSCarpal Tunnel Points: 4092 More actions · Answer 2

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?

Igor Micev SSC-Dedicated Points: 33109 More actions · Answer 3

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

Revenant SSC-Forever Points: 42467 More actions · Answer 4

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

Thanks, Kapil!

SQLRNNR SSC Guru Points: 281334 More actions · Answer 5

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

Alvin Ramard SSC-Forever Points: 41190 More actions · Answer 6

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]