Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- EXEC sp_query_store_flush_db;
- SELECT * INTO Admin.dbo.query_store_runtime_stats FROM sys.query_store_runtime_stats;
- SELECT * INTO Admin.dbo.query_store_runtime_stats_interval FROM sys.query_store_runtime_stats_interval;
- SELECT * INTO Admin.dbo.query_store_plan FROM sys.query_store_plan;
- SELECT * INTO Admin.dbo.query_store_query FROM sys.query_store_query;
- SELECT * INTO Admin.dbo.query_store_query_text FROM sys.query_store_query_text;
- IF EXISTS(select * FROM sys.views where name = 'query_store_wait_stats') -- View not in SQL 2016
- Begin
- SELECT * INTO Admin.dbo.query_store_wait_stats FROM sys.query_store_wait_stats;
- End
- SELECT * INTO Admin.dbo.query_context_settings FROM sys.query_context_settings;
- select * FROM sys.views where name = 'sys.query_store_wait_stats'
- USE <database_name>;
- GO
- SELECT name AS view_name
- ,SCHEMA_NAME(schema_id) AS schema_name
- ,OBJECTPROPERTYEX(object_id,'IsIndexed') AS IsIndexed
- ,OBJECTPROPERTYEX(object_id,'IsIndexable') AS IsIndexable
- ,create_date
- ,modify_date
- FROM sys.views;
- select * FROM sys.views where name = 'sys.query_store_wait_stats'
- SELECT *
- -- DISTINCT NAME
- FROM SYS.OBJECTS
- WHERE TYPE IN ('U','V')
- AND NAME= 'query_store_wait_stats'
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement