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;