Sample Header Ad - 728x90

Tracking stored procedure performance metrics

3 votes
2 answers
411 views
I’m trying to track impacts of stored procedure executions - CPU time, execution duration, logical/physical reads, memory grants, etc. - in order to visualize them. In particular, I'm looking for results of a stored procedure as a whole, not of any individual statements within. I’ve explored several options - wrappers, DMVs, sp_WhoIsActive, custom logging procedures, etc. - but I’m still not fully convinced by the approaches I’ve used so far. How can I reliably capture stored procedure performance metrics over time?
Asked by Kaaniche Emna (31 rep)
Jul 24, 2025, 02:51 PM
Last activity: Jul 29, 2025, 05:33 PM