• Don't trust the task manager, it's a blatant liar!
    😎

    What is the output of this code?

    SELECT
      OSM.total_page_file_kb
     ,OSM.available_page_file_kb
     ,OSM.total_page_file_kb
     ,OSM.available_page_file_kb
     ,OSM.system_cache_kb
     ,OSM.kernel_paged_pool_kb
     ,OSM.kernel_nonpaged_pool_kb
     ,OSM.system_memory_state_desc
    FROM sys.dm_os_sys_memory OSM;

    SELECT
     ISNULL(DB_NAME(OBD.database_id),'ResourceDB') AS DBNAME
    ,OBD.page_type           AS page_type
    ,SUM(OBD.row_count)          AS SUM_row_count
    ,SUM(OBD.free_space_in_bytes)      AS SUM_free_space_in_bytes
    ,SUM(OBD.read_microsec)        AS SUM_read_microsec
    FROM sys.dm_os_buffer_descriptors OBD
    GROUP BY DB_NAME(OBD.database_id)
       ,OBD.page_type
    ORDER BY DB_NAME(OBD.database_id) ASC
       ,OBD.page_type    ASC;