• Grant,

    The query with the largest numbers against it is the second one in the list:

    INSERT INTO @MemStat

    EXEC ('DBCC memorystatus() WITH tableresults');

    From query plan: 0x06000100e090292b40e18282000000000000000000000000

    *****************************************************************

    Thje metrics are:

    execution count = 4, duration(ms) = 401, cpu time(ms) = 399, physical reads = 0, logical reads = 1858, logical writes = 0

    These are the metrics next to the tsql text - do i need to look at anything else ?