SQL Performance Reports - but for a date range

Question

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.

Answer 1

You can download the SSMS Performance Dashboard Reports from here and use as Custom reports with SQL Server 2008, SQL Server 2008 R2, SQL Server 2012, SQL Server 2014. Having access to the rdl file you can customize it however you want.

Also worth reading this.