Last Run Date on a Stored Procedure with parameter values

Question

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Ant-Green SSC Guru Points: 113507 More actions · Answer 1

Last execution time - Yes - look at sys.dm_exec_procedure_stats

Last executed parameters - No - you will need to create extended event sessions to capture that information

skb 44459 SSCarpal Tunnel Points: 4768 More actions · Answer 2

SSCarpal Tunnel

Points: 4768

September 2, 2021 at 2:20 pm

Any idea on how to do that?

Michael L John One Orange Chip Points: 27060 More actions · Answer 3

This is a great resource on Extended Events

Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/