Query Store Catalog Views – Part 6

Disclaimer :  Subject to change with new CTP updates.

FROM BOL:

The Query Store can be viewed and managed through Management Studio or by using the following views and procedures.

sys.fn_stmt_sql_handle_from_sql_stmt

Query Store Catalog Views
Gives detail information about the Query Store.

sys.database_query_store_options
sys.query_context_settings 
sys.query_store_plan 
sys.query_store_query 
sys.query_store_query_text 
sys.query_store_runtime_stats
sys.query_store_runtime_stats_interval

Query Store Stored Procedures

Stored procedures to configure the Query Store manually.

sp_query_store_flush_db
sp_query_store_reset_exec_stats
sp_query_store_force_plan
sp_query_store_unforce_plan
sp_query_store_remove_plan
sp_query_store_remove_query

Leave a Reply

Your email address will not be published. Required fields are marked *