July 16, 2015 at 10:20 am
HI all,
As SQL Server 2016 category is not created so I am posting this query in SQL Server 2014 window.
I have enabled Query Store in SQL Server 2016 using ALTER DATABASE and later tried with Properties of Database too. But I am not able to see the Query Store subfolder under database.
Can anybody help me on this why I am not able to see that folder.
Thanks in advance.
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
July 16, 2015 at 10:27 am
What version of Management Studio are you using? (Help->About)
What does this return?
select name, is_query_store_on from sys.databases
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 16, 2015 at 10:32 am
Using SQL version SQL Server 2016 CTP2...
After running that query its returning me value 1 for database on which I enabled Query store ON.
name is_query_store_on
AdventureWorks2014 1
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
July 16, 2015 at 10:35 am
Not asking about SQL's version. Asking about Management Studio.
Tried restarting SSMS?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 16, 2015 at 10:45 am
GilaMonster (7/16/2015)
Not asking about SQL's version. Asking about Management Studio.Tried restarting SSMS?
Already tried but nothing happened...
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
July 16, 2015 at 11:47 pm
using SSMS version 13.0
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
July 17, 2015 at 3:17 am
Weird. I had problems initially enabling query store, but once enabled it worked fine.
Can you post a screenshot of Object Explorer expanded out?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 4, 2018 at 10:40 am
You need latest version of SSMS
October 4, 2018 at 10:46 am
rpetit1230 - Thursday, October 4, 2018 10:40 AMYou need latest version of SSMS
Three year old post, just so you know. I think 13 was the current version at the time.
May 31, 2019 at 8:55 pm
This was an old post but it happened to me just now using SSMS 18.0 when connecting to SQL Server 2016. The Query Store folder was missing because I didn't have the VIEW DATABASE STATE permission.
"To use Query Store the VIEW DATABASE STATE permission is needed. To data flush Interval, force execution plan, etc., the db_owner fixed database role is required." I searched for a while before I found that out. This article saved me:
https://solutioncenter.apexsql.com/visual-tools-for-monitoring-sql-server-query-performance/
Viewing 10 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply