The procedure-cache tag has no wiki summary.
4
votes
1answer
78 views
Execution Plan Regeneration
we have a database server with Sql Server 2008R2 that runs some queries every day; now these queries are fast (I suppose Sql Server has in memory some good execution plans).
If we restart the ...
6
votes
1answer
260 views
Why does the plan cache contain estimated and not actual execution plans?
I can think of many reasons behind this decision of storing estimated plans in the plan cache and not the actual plan. But I can't find the "correct" answer.