Home Forums SQL Server 2008 SQL Server 2008 Administration Memory Clerks Discrepancy RE: Memory Clerks Discrepancy

  • March 1, 2013 at 6:35 am

    #1592340

    opc.three (2/28/2013)

    The 'SQL Plans' cache includes plans for both 'Ad Hoc' and 'Prepared' queries.

    Thanks

    Taking into account the fact that SQL plans consists of Adhoc and Prepared queries - The total MB's reported in sys.dm_exec_cached_plans is still very far off from the value in MB's reported in memory clerks.

    Any Ideas?