Eirikur Eiriksson - Thursday, March 1, 2018 1:32 AM

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;