Post reply

Query Store folder not visible in SQL Server 2016

  • July 16, 2015 at 10:20 am

    #318987

    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

    #1813062

    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

  • July 16, 2015 at 10:32 am

    #1813066

    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

    #1813067

    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

  • July 16, 2015 at 10:45 am

    #1813072

    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

    #1813168

    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

    #1813200

    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

  • October 4, 2018 at 10:40 am

    #2008144

    You need latest version of SSMS

  • October 4, 2018 at 10:46 am

    #2008146

    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.

  • May 31, 2019 at 8:55 pm

    #3649176

    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

Cookies on SQLServerCentral

This website stores cookies on your computer.

These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.

To find out more about the cookies we use, see our Privacy Policy