That per-second counter on your dashboard is probably a running total. Here is how to turn it into a real rate with two samples.
TRY_CAST vs CAST: Finding Rows That Will Not Convert Before a Load
Find text values that will not convert before loading, separate invalid and missing input, and use explicit date styles and culture parsing.
INSERT EXEC: Capturing a Procedure’s Result Set and Its Limits
Capture rows with INSERT EXEC, match result columns, understand nested and multiple-result limits, and choose supported alternatives.
Approximate Percentiles With APPROX_PERCENTILE_CONT
Use APPROX_PERCENTILE_CONT for large response-time summaries, compare exact percentiles, and interpret the documented rank error bound.
Finding Schedule Clashes: Overlapping Sessions per Attendee
An attendee says two sessions run at the same time. Here is how to find every overlapping pair once, and why touching is not a clash.
Finding Queries That Spill With total_spills in Query Stats
Rank total_spills and recent counters, inspect plans, compare Query Store tempdb use, and investigate estimates before increasing grants.
Agent Job Step Retries: Retry Attempts and Retry Interval
Configure Agent retry attempts and minute intervals, inspect retry history, and distinguish transient failures from unsafe replays.