SQL Server Memory allocation windows

Alejandro Melo Pineda 20 Reputation points
2023-01-12T22:57:24.96+00:00

Hi,

We have a production virtual server in azure with SQL Server 2019 CU-18 Standard in Windows Server 2019 Datacenter.

And the server has 128 GB RAM, the sql instance has 56 GB of RAM in Maximum server memory.

The question is its normal or not that every time we reboot the server the SQL instance only reserves between 2 and 6 GB of the ram and eventually the SQL service reserve the whole 56 GB.

Thanks.

Azure Virtual Machines
Azure Virtual Machines
An Azure service that is used to provision Windows and Linux virtual machines.
8,365 questions
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,479 questions
{count} votes

Accepted answer
  1. Seeya Xi-MSFT 16,571 Reputation points
    2023-01-13T06:46:00.5833333+00:00

    Hi Alejandro Melo Pineda,

    Yes. This is completely normal. It is expected behavior for SQL Server to use all available RAM on the server.  This not an indication of a problem.

    What is more, I put related document here:

    https://learn.microsoft.com/en-us/sql/database-engine/configure-windows/server-memory-server-configuration-options?view=sql-server-ver16&viewFallbackFrom=sql-server-2014

    Best regards,

    Seeya


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

    2 people found this answer helpful.
    0 comments No comments

1 additional answer

Sort by: Most helpful
  1. Armando Lacerda 11 Reputation points MVP
    2023-01-13T00:29:35.09+00:00

    Hi @Alejandro Melo Pineda ,

    Yes, that is the regular SQL behavior. As queries come through, SQL will start filling up the data buffers and requesting more memory.

    As long as there is available memory on the server, this does not affect performance besides the "warm up" of reading the data from storage.

    Hope this helps.

    2 people found this answer helpful.
    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.