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
Last activity: Jul 29, 2025, 05:33 PM