RE: Results of sys.dm_exec_procedure_stats are disordered

SSC Guru

Points: 1003863

May 2, 2016 at 9:13 am

MotivateMan1394 (5/1/2016)
No , The opposite . I expected see the execution count on the ascending Order.
It means every day should be more than prev day. Because value of execution count is Cumulative.
(But I see untidy in the results. I guess it relates to a memory problem. I am really worry about frequently reset of cached_time. )

Ah, got it. Like Jacob stated, it's not just server restarts that remove or restart such entries. Entries come and go depending on whether there's room for them or not.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)