SQL Server comes with very handy "performance" reports: in SSMS - right-click the server - "reporting" - "Standard" - you see many useful reports, like "Top queries by Total CPU time", "Top queries by average I/O" etc.
These reports aggregate the data since last restart or since last query stats reset.
Is there any way to see these reports for a date range? Like "Top queries by total CPU time from 10pm to 11pm"? Maybe there's an SQL Server addon on or service that should be installed or something, that would allow this kind or research?
Real life use case: a DBA wakes up and sees there were some "timeout" errors during the night. He wants to see which queries were running at the moment and eating up performance.
Found this series of blog posts at SQLShack that advises installing "Data Collectors" that continuously record performance data, so you can analyse it later: SQL Server performance monitoring with Data Collector