Team,
Sqlserver.exe is consuming high memory. Total memory is assigned 128GB out of that 120GB is consumed by sqlserver.exe. I know its by design sql will grab all the memory from the OS. Server is hosted on shared Data center.
my question: How we confirm how much RAM is needed ? so that it will not impact the server performance. Do we have any tool to analysis the how much memory /cpu needed? on what basis I can confirm to customer SQL need more memory?