By default, Amazon RDS for SQL Server dynamically manages its memory. It will request extra memory from the operating system as required to satisfy the queries being run.
This dynamic memory management means Amazon RDS for SQL Server can automatically tune its memory allocations based on the load it is processing and the demands of other processes on the server.
Each page of memory used by Amazon RDS for SQL Server is assigned to one of several caches. Each cache will grow and shrink in size as required. The main caches are the Buffer Cache, which holds recently accessed database pages, and the Procedure Cache, which holds recently compiled query execution plans.
This Memory gauge shows the total amount of memory currently allocated to Amazon RDS for SQL Server.
The maximum value shown on this gauge is the lower of Amazon RDS for SQL Server’s Max Memory parameter and the amount of physical RAM on the machine. It indicates the maximum amount of memory that Amazon RDS for SQL Server can use.
Amazon RDS for SQL Server parameters can be used to influence the amount of memory that Amazon RDS for SQL Server uses. The default maximum amount of memory (Max Memory) is 2147483647 MB. The minimum memory amount allowable for max server memory is 128 MB.