have you set min and max memory in the instance properties? If so, to what values? If not, set them to reasonable values. Min should be no more than the average working set. Max should be no more than 2 GB less than available memory (fwiw 95% of 32gb is 30.4 gb). But you have to make allowance for any other processes on the server (e.g. other SQL instances)Note that SQL Server will return unused memory to the OS but not go below the min value.Run this query and post the results:SELECT(physical_memory_in_use_kb/1024) AS Memory_usedby_Sqlserver_MB,(locked_page_allocations_kb/1024) AS Locked_pages_used_Sqlserver_MB,(total_virtual_address_space_kb/1024) AS Total_VAS_in_MB,process_physical_memory_low,process_virtual_memory_lowFROM sys.dm_os_process_memory;
memory usage after Reorganization index
Posted - 2015-02-04 : 09:35:20
