I have my SQL Server 2008 R2 installed running on 32GB ram. I need to decrease the limit SQL Server uses to 28 GB and I have set the same to 28GB but it is still taking more. I have seen posts saying
max memory is for buffer pool only. Ultimately what I require is the OS utilization should not go above 90% which is why I kept the max memory to 28GB hoping the OS utilization would come down.. but its not happening. What are the solutions?
I have run this query:
SELECT type, virtual_memory_committed_kb, multi_pages_kb FROM sys.dm_os_memory_clerks WHERE virtual_memory_committed_kb > 0 OR multi_pages_kb > 0
type virtual_memory_committed_kb multi_pages_kb MEMORYCLERK_SQLBUFFERPOOL 29169592 416 OBJECTSTORE_LOCK_MANAGER 131072 0 MEMORYCLERK_SQLSTORENG 53312 17744 MEMORYCLERK_SQLCLR 10612 14792 MEMORYCLERK_XE_BUFFER 4224 0 MEMORYCLERK_SQLUTILITIES 120 0
select * from sys.dm_os_process_memory;
physical_memory_in_use_kb 30599208 ~ 29G large_page_allocations_kb 0 locked_page_allocations_kb 0 total_virtual_address_space_kb 8589934464 virtual_address_space_reserved_kb 39439648 virtual_address_space_committed_kb 31066216 ~ 30G virtual_address_space_available_kb 8550494816 page_fault_count 16996946 memory_utilization_percentage 99 available_commit_limit_kb 32705384 process_physical_memory_low 0 process_virtual_memory_low 0