Abrar Ahmad_ (4/4/2011)
[font="Verdana"]Grant, if following tiny confusion can be explained?Do DMV/Fs provide "Actual Execution Plan" or "Estimated Execution plan" specially Sys.DM_exec_Query_Plan?
Logically it should be "Actual Execution Plan" rather than "Estimated Execution plan"! But XML from DMV/Fs does not contain any <RunTimeInformation> tag! 🙂
Thanks!
[/font]
What you are pulling out of the cache is an estimated plan. The actual plans, with performance metrics based on the parameters passed are not stored.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning