memory usage (MEMORYCLERK_SQLBUFFERPOOL) keeps increasing in sql server management studio

andi rafian 26 Reputation points

I use sql server management studio 17.9.1 with redundant working system
PC has a memory capacity of 32GB
initial setting of 20GB memory usage at SQL server
the problem is that memory usage will continue to rise, until it reaches 20GB (MAX) within 1 month

and resetting memory usage from 20GB to 25GB From 32GB
25/04/2022 15:00 SQL server memory usage 23.5 GB
26/04/2022 15:50 SQL server memory usage 24,99 GB

after checking the large memory problem is in MEMORYCLERK_SQLBUFFERPOOL

how to deal with this problem memory usage keeps increasing?


thank You
by Andi

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
9,846 questions
SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,364 questions
SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,103 questions
0 comments No comments
{count} vote

Accepted answer
  1. Erland Sommarskog 78,346 Reputation points MVP

    The database is not very big, only around 60 GB, not including the log file. (And the log file does not matter when it comes to estimations of how much RAM you need.)

    As I discussed in my previous post, you either need to tune queries or add RAM. Since you don't seem to be very knowledgeable about SQL Server, I guess adding RAM is the easier option. Given the size of the database, 64 GB should be enough.

4 additional answers

Sort by: Most helpful
  1. Olaf Helper 29,121 Reputation points

    how to deal with this problem memory usage keeps increasing?

    What for a problem, do you have performance issues?
    It's normal and by design that SQL Server allocate as much memory as it needs and as it can get.

  2. CathyJi-MSFT 20,981 Reputation points Microsoft Vendor

    Hi @andi rafian ,

    If you’re going to run other software on the server, you can set SQL Server’s maximum amount of memory to leave memory free for other applications. If there is no other software on this server, SQL Server will allocate as much memory as it needs and as it can get. And SQL Server never lets go or releases memory unless the server comes under memory pressure (like if other apps need memory and Windows sends out a memory pressure notification).

    Below is a blog to help you better understood this.

    A Sysadmin’s Guide to Microsoft SQL Server Memory

    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

  3. Tom Phillips 17,636 Reputation points

    That is completely normal and expected behavior. SQL Server never releases RAM once it is allocated unless there is a low memory message sent from Windows.

    If your system is low on RAM, you should set the max server memory smaller. That will reserve more RAM for other applications.

  4. Erland Sommarskog 78,346 Reputation points MVP

    As I understand it, this is a machine dedicated to SQL Server. If SQL Server starts to run slow when you hit the limit, this suggests that queries are constantly reading more data than fits into the buffer cache. Yes, this makes the machine slow.

    The simple resolution is to add more memory to the machine. 24 GB is not much for a database server.

    The other alternative is to analyse and tune the workload so that it runs more efficient queries.