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;
Hi
This is output after reboot
---------------
total_page_file_kb |
7339512 |
|
available_page_file_kb |
5600084 |
|
total_page_file_kb |
7339512 |
|
available_page_file_kb |
5600084 |
|
system_cache_kb |
1293788 |
|
kernel_paged_pool_kb |
170576 |
|
kernel_nonpaged_pool_kb |
55228 |
|
system_memory_state_desc |
Available physical memory is high |
-----
Thank you