SCCM | Intune | Windows 365 | Autopilot | Windows 11 Forums

Register a free account today to become a member! Once signed in, you'll be able to participate on this site by adding your own topics and posts, as well as connect with other members. Please post your questions in the correct category.

SOLVED SQL Server taking all Memory of server

Status
Not open for further replies.
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
 
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/
 
Status
Not open for further replies.

Forum statistics

Threads
6,288
Messages
24,647
Members
14,729
Latest member
Yuen.kwok
Back
Top