SOLVED SQL Server taking all Memory of server

[vikrant disale]

Hello All,
We have 1 Server installed with MSSQL server 2008R2 the server have 256 GB RAM.

but the thing is that 94% RAM is utilizing by SQL Application.

Could you please suggest how to resolve this issue or how i can trace which SQL service or query utilizing high memory.

Regards,
Vikrant

 

[Prajwal Desai]

During the installation of SCCM, did you define memory limits ?. By default, SQL Server Standard will dynamically use up memory based on what resources are available (2 TB). So it usually eats up all available memory on a system and not release it back until the service is restarted. You can limit the sql memory by logging into SQL management studio > right click server > properties > memory. Set min and max memory as per requirements.

Check this post (at the end) - https://prajwaldesai.com/installing-sql-server-2012-for-configuration-manager-2012-r2/

 

[vikrant disale]

Perfect Gotcha ..

Thank you so much Prajwal Its worked

 

[Prajwal Desai]

Yup.. Marking this thread as solved.