The only two runtime data sets that we poll and save periodically is the below querying the Query Store.
Would you suggest to save more columns and or possibly a better TopQueries collector as this? Is there a better way of saving this kind of performance metrics? Should We be saving more than just 25 in a batch? (I inherited this repository from DBAs and now need to make sense out of it and stop unnecessary data collector jobs and possibly introduce new collector routines).
insert into DBA_Utilities.dbo.TOPqueries
select top 25 getdate(), t.query_sql_text,r.last_logical_io_reads,
from sys.query_store_query as q
join sys.query_store_query_text as t
join sys.query_store_plan as p
join sys.query_store_runtime_stats as r
order by r.avg_duration desc
Voldemar likes to play CHESS (and IS good at it!)