By default, SQL Azure 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 SQL Azure can automatically tune its memory allocations based on the load it is processing and the demands of other processes on the hosted Azure.
Each page of memory used by SQL Azure 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 SQL Azure.
The maximum value shown on this gauge is the lower of SQL Azure’s Max Memory parameter and the amount of physical RAM on the machine. It indicates the maximum amount of memory that SQL Azure can use.
SQL Azure parameters can be used to influence the amount of memory that SQL Azure uses. The default maximum amount of memory (Max Memory) is 2147483647 MB. The minimum memory amount allowable for max server memory is 128 MB.