Why is SQL Server consuming Lot of RAM

Posted on : 05-01-2012 | By : Devi Prasad | In : Configuring SQL Server, SQL Server Basics, SQL Server Issues, SQL Server Management, SQLServerPedia Syndication


Why is SQL Server consuming Lot of RAM

There could be multiple reasons why SQL Server is consuming lot of physical memory (RAM).

Following are the few that I would like to list out:

1) Performance of the server could be bad as the queries that are hitting the sever are not optimal.
You can further fine tune such queries.

2) Maximum and Minimum server memory configuration is not set up properly.
You can set up maximum server memory configuration so that it doesnt eat up whole of the RAM.

Following are the Steps to configure sql server memory allocation:

  • Connect to the SQL Server in SQL Server management studio
  • Right click on the server and click on properties
  • Now the Server Properties window pops up.
    In the Server Properties window Select Memory.
    Now check the values of
    Minimum Server Memory(in MB) and Maximum Server Memory(in MB)

    Configure Maximum And Minimum SQL Server Memory

    Configure Maximum And Minimum SQL Server Memory

  • Adjust these values to opimal memory values as per your SQL Server’s memory requirement.

Note: Be aware that changing the memory configuration of SQL Server might give you very bad results. Hence be cautious before making such changes.
You might also get There is insufficient system memory in resource pool ‘default’ to run this query error if memory configuration is bad.

Reference : Devi Prasad (sqlserverlearner.com)

Do you like my blog?

If you liked reading this blog, please help spread the word by sharing this blog with your friends.

Need Help On SQL Server?

Cannot Find Solution to your problem (or) If you are looking for some help on SQL Server. Dont worry Click Here to Post your question and solve your issue.

Your Ad Here

Tags: , , , , , , , , , , , , , , , , ,