Status rows hold timestamps, not durations. I use LEAD to measure each step, keep unfinished steps NULL, and show why zero ruins your averages.
Offloading Reports to a Readable Secondary
Readable secondary replicas can serve reports away from a SQL Server primary; learn routing, lag, licensing, and query differences to test.
Row-Level Security for Reports
Use SQL Server row-level security for reports with predicate functions and SESSION_CONTEXT, and test every identity boundary.
Fiscal Years That Do Not Start in January
Compute fiscal years and quarters from an April start, build indexed date boundaries, and store a fiscal calendar for repeatable reports.
Percent of Total With SUM() OVER() in One Query
Calculate percent of total with SUM() OVER(), group and running shares, safe numeric division, and checks for zero totals.
SQL SERVER – Configure Management Data Collection in Quick Steps – T-SQL Tuesday #005
A visual walk through to configure Management Data Collection in a few quick steps and get default reports on CPU, memory and disk for your server.
SQL SERVER – Out of the Box – Activity and Performance Reports from SSSMS
SSMS 2008 has built-in activity and Performance Reports most people never open. Right click the server, go to Reports, Standard Reports, and pick one.