Popular Posts

SQLblog.com - The SQL Server blog spot on the web

Sunday, December 10, 2017

dm_os_process_memory shows more memory usage than dm_os_memory_clerks & dm_os_buffer_descriptors

SQLServerCentral » Latest topics
dm_os_process_memory shows more memory usage than dm_os_memory_clerks & dm_os_buffer_descriptors
Hi,
I'm looking for some help finding some missing memory and how to reclaim it without restarting the SQL service.

The original issue:
A SSIS package is hanging on a sort operation. Only ~860K rows, ~45 bytes per row = ~37 MB.
This

No comments: