Query Store folder not visible in SQL Server 2016

  • 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/

  • 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

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass
  • 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/

  • 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

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass
  • 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/

  • using SSMS version 13.0

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

  • 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

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass
  • You need latest version of SSMS

  • rpetit1230 - Thursday, October 4, 2018 10:40 AM

    You need latest version of SSMS

    Three year old post, just so you know.  I think 13 was the current version at the time.

  • 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