Advertisement
Guest User

Untitled

a guest
Jul 16th, 2019
56
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.23 KB | None | 0 0
  1. EXEC sp_query_store_flush_db;
  2.  
  3. SELECT * INTO Admin.dbo.query_store_runtime_stats FROM sys.query_store_runtime_stats;
  4. SELECT * INTO Admin.dbo.query_store_runtime_stats_interval FROM sys.query_store_runtime_stats_interval;
  5. SELECT * INTO Admin.dbo.query_store_plan FROM sys.query_store_plan;
  6. SELECT * INTO Admin.dbo.query_store_query FROM sys.query_store_query;
  7. SELECT * INTO Admin.dbo.query_store_query_text FROM sys.query_store_query_text;
  8. IF EXISTS(select * FROM sys.views where name = 'query_store_wait_stats') -- View not in SQL 2016
  9. Begin
  10. SELECT * INTO Admin.dbo.query_store_wait_stats FROM sys.query_store_wait_stats;
  11. End
  12. SELECT * INTO Admin.dbo.query_context_settings FROM sys.query_context_settings;
  13.  
  14. select * FROM sys.views where name = 'sys.query_store_wait_stats'
  15.  
  16. USE <database_name>;
  17. GO
  18. SELECT name AS view_name
  19. ,SCHEMA_NAME(schema_id) AS schema_name
  20. ,OBJECTPROPERTYEX(object_id,'IsIndexed') AS IsIndexed
  21. ,OBJECTPROPERTYEX(object_id,'IsIndexable') AS IsIndexable
  22. ,create_date
  23. ,modify_date
  24. FROM sys.views;
  25.  
  26. select * FROM sys.views where name = 'sys.query_store_wait_stats'
  27.  
  28. SELECT *
  29. -- DISTINCT NAME
  30. FROM SYS.OBJECTS
  31. WHERE TYPE IN ('U','V')
  32. AND NAME= 'query_store_wait_stats'
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement