Execution Plan Caching: Procedure cache

enrique_aeo
enrique_aeo used Ask the Experts™
on
hi experts, i am reading about Execution Plan Caching, but i do not understand Procedure cache
(age and cost)
can you explain me please
procedureCACHE.jpg
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Racim BOUDJAKDJIDatabase Architect - Dba - Data Scientist

Commented:
<<hi experts, i am reading about Execution Plan Caching, but i do not understand Procedure cache
(age and cost)>>
What exactly are you reading ?
Racim BOUDJAKDJIDatabase Architect - Dba - Data Scientist

Commented:
What exactly don't you understand ?

Author

Commented:
Removing Execution Plans from the Procedure Cache
this part
 Procedure cache
(age and cost)
Database Architect - Dba - Data Scientist
Commented:
Well, in summary the article simply explains the mechanism by which SQL removes plans from cache on a cost based approach.  The Age could be considered the time the plan stays in the cache until removed.  And the Cost refers to a flag SQL uses to determine best candidate for removal in order to free up space.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial