How to enable query store on the SSMS object browser with Sql Azure? I am following this guide: Monitoring Performance By Using the Query Store


I am using SSMS 2016 CTP3.2 and Sql Azure V12
I have enabled the query store on the database properties. 
I can use the query performance insight on the azure portal.


But when I open the azure database on SMSS 2016 CTP3.2 and expand the database tree, the Query Store / Regressed Queries or any other options are available.

I want to be able to take the most IO consuming queries and analyze the execution plan.

Anything else I have to enable?

The relevant is_query_store_on column in sys.databases shows 0, but the database properties says it is enabled. I executed ALTER DATABASE &lt;DB&gt; SET QUERY_STORE = ON; but is_query_store_on still stays at 0.

The following query:

SELECT 
    actual_state, actual_state_desc, readonly_reason, 
    current_storage_size_mb, max_storage_size_mb
FROM sys.database_query_store_options;


Shows actual_state = 2;
This fixed my problem:


Disabling the query store by command:

ALTER DATABASE &lt;DBNAME&gt; SET QUERY_STORE = OFF;

Then enabling it again fixed the problem.

ALTER DATABASE &lt;DBNAME&gt; SET QUERY_STORE = ON;