CODEWITHSUNDEEP
sqlsql-serversql-server-2008
Kundan
Kundan

Reputation: 109

How can get the stored procedure execution logs?

I know that how many times it was executed from execution_count in sys.dm_exec_procedure_stats.

But how these values are calculated?

Is there any way to know how these values get calculated?

I want whole log when the stored procedure was first time executed to till last_execution_time logs.

Upvotes: 2

Views: 18098

Answers (1)

ErikEJ
ErikEJ

Reputation: 41749

The statictics are reset each time the server restarts, and the DMV is documented here: https://msdn.microsoft.com/en-us/library/cc280701.aspx

Upvotes: 3

Related Questions