we are using sql 20014. system specifications :4CORE &128GB RAM . We configured max memory 110460 mb & min memory as 1024 kb.
Users complaining that SQL peformance is very slow.
when we checked the task manager sql.exe utilising 62 % memory.
when i tried to check the memory using below query its showing that 72 gb memory is using.
from sys. dm_os_process_memory
Memory_usedby_Sqlserver_MB =72720 mb.
somehow it is confirmed that SQL Server is not using configured memory.
How to make sure the sql server using high memory? please help. I need to ressolve this as soon as possible.