I am looking for a way to count the number of times a stored procedure on the database has been executed over let's say over a period of time(month, years, etc).
Is there a system stored procedure or a system table that stores that information.
I am struggling to find some information about this topic
Thanks for the helpI don't know if that information is stored, but what you can do is to create your own table that will store the datetime the stored-procedure is run. You can then run your queries on that table.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment