What part of max memory is being used?

Thanks for confirming the version

You can use below query to find Total Memory utilized by SQL Server

select
(physical_memory_in_use_kb/1024)Memory_usedby_Sqlserver_MB,
(locked_page_allocations_kb/1024 )Locked_pages_used_Sqlserver_MB,
(total_virtual_address_space_kb/1024 )Total_VAS_in_MB,
process_physical_memory_low,
process_virtual_memory_low
from sys. dm_os_process_memory

Let me tell you what max server memory controls in SQL Server 2012 and 2014

Max server memory controls SQL Server memory allocation, including the buffer pool, compile memory, all caches, qe memory grants, lock manager memory, and CLR memory (basically any “clerk” as found in dm_os_memory_clerks). Memory for thread stacks, heaps, linked server providers other than SQL Server, or any memory allocated by a “non SQL Server” DLL is not controlled by max server memory.

You can see max server memory value from sp_configure. Look for Max server memory and see config value.

SQL Server memory manager is dynamic in nature and adjust memory as per memory notifications given.

Object - SQLServer:Memory Manager: Total Server Memory (KB) is what SQL server is using actually

Object - SQLServer:Memory Manager: target Server Memory (KB) is what SQL server is speculating that would access in to perform smoothly.

You can query these counters from below query as well

select * from sys.dm_os_performance_counters

Do let me know if you require any further information.

---

Please mark this reply as answer if it solved your issue or vote as helpful if it helped so that other forum members can benefit from it



My Technet Wiki Article

MVP