Home Forums SQL Server 2005 Administering sys.dm_exec_cached_plans : Total plans in the procedure cache and total memory size mobilized RE: sys.dm_exec_cached_plans : Total plans in the procedure cache and total memory size mobilized

  • memory management is controled by sql server

    when it requires it gets memory by deleting some plans from the cache

    you can still release memory from plan cache by doing

    dbcc freeproccache

    but the case you described above is that both the queries are the same.

    second one is best practise.

    [font="Tahoma"]
    --SQLFRNDZ[/url]
    [/font]