cached query plans

• bodhilove

  SSCarpal Tunnel

  Points: 4035

  More actions

  February 18, 2009 at 4:41 pm

  #134921

  Is there any way you can work out how long cached query plans will be cached for (dm_exec_cached_plans)?

• SQL ORACLE

  One Orange Chip

  Points: 27807

  More actions

  February 18, 2009 at 7:26 pm

  #946441

  The following article may help.

  http://www.sqlknowledge.com/index.php/articles/35-administration/67-how-long-does-a-sp-stay-in-the-cache-

• bodhilove

  SSCarpal Tunnel

  Points: 4035

  More actions

  February 18, 2009 at 8:19 pm

  #946448

  yes that is helpful - thanks