2

I want to get stats from the sys.dm_exec_procedure_stats view.

When I check the records from months ago, I see that after a point of time its stats reset daily, but there have been no server resets.

It seems there is a job running that makes this view reset. Can anyone help me with this problem? What kind of procedures will reset these views?

Paul White
  • 83,961
  • 28
  • 402
  • 634
Milad Firouzi
  • 129
  • 1
  • 2
  • 12

1 Answers1

2

From the docs

The view returns one row for each cached stored procedure plan, and the lifetime of the row is as long as the stored procedure remains cached. When a stored procedure is removed from the cache, the corresponding row is eliminated from this view.

This dmv is therefore reset for each stored procedure recompile, which can happen, for example, after index and statistics maintenance

gbn
  • 69,809
  • 8
  • 163
  • 243