Log Shipping & Query Plans

I have noticed that on our setup that every time the Log Shipping restore
happens, dm_exec_cached_plans and dm_exec_query_stats get completly whiped
out. Is this normal?
We are running on Sql Server 2005 Enterprise Edition SP1 on Windows Server
2003 R2 EE
Hi Bryan,
This is the expected behavior based on the current design.
We are considering of changing the design to allow the presevarion of
cached plans after a restore, in the next release of SQL Server.
Regards,
Leo
"Bryan Aldrich" <BryanAldrich@.discussions.microsoft.com> wrote in message
news:F1F94B7D-8664-4658-B73D-6B7137B9B618@.microsoft.com...
>I have noticed that on our setup that every time the Log Shipping restore
> happens, dm_exec_cached_plans and dm_exec_query_stats get completly whiped
> out. Is this normal?
> We are running on Sql Server 2005 Enterprise Edition SP1 on Windows Server
> 2003 R2 EE
|||Thanks
"Leo Giakoumakis [MS]" wrote:

> Hi Bryan,
> This is the expected behavior based on the current design.
> We are considering of changing the design to allow the presevarion of
> cached plans after a restore, in the next release of SQL Server.
> Regards,
> Leo
>
> "Bryan Aldrich" <BryanAldrich@.discussions.microsoft.com> wrote in message
> news:F1F94B7D-8664-4658-B73D-6B7137B9B618@.microsoft.com...
>
>