Hi,
I am using SQL server 2014 (dedicated server) with Windows server 2012 R2.
Total memory =48 gb
Minimum server memory =0
Maximum server memory = 35 gb.
Problem is that memory often goes up to 95% without any performance issue.
No query is stuck in there.
I have observed many times , during the time if I execute following query:
( SELECT
physical_memory_kb/1048576.0 physical_memory_GB,
virtual_memory_kb/1048576.0 virtual_memory_GB,
committed_kb/1048576.0 committed_GB,
committed_target_kb/1048576.0 committed_target_GB
FROM sys.dm_os_sys_info; )
It shows committed_GB, committed_target_GB less than 35 GB. Which means some other process is grabbing memory.
Task manager shows SQL server process taking more memory but its in mbs (most of time less than 500 mbs).
Tried to get it through reading different articles & different forums but no satisfaction.
Any help please.
Thanks in advance.