Memory issue on Azure SQL Server VM

Hello Vijay Kumar

Please be informed that Minimum and Maximum Server memory shown are the limits.

Memory utilization for the SQL Server Database Engine is bounded by a pair of configuration settings, min server memory (MB) and max server memory (MB).

Set max SQL Server memory limit to leave enough memory for the Operating System. (Use Memory\Available Bytes to monitor the operating system memory health).

Use min server memory (MB) and max server memory (MB) to reconfigure the amount of memory (in megabytes) managed by the SQL Server Memory Manager for an instance of SQL Server.

In Object Explorer, right-click a server and select Properties.

Select the Memory page of the Server Properties window. The current values of Minimum server memory and Maximum server memory are displayed.

In Server memory options, enter desired numbers for Minimum server memory and Maximum server memory. For recommendations, see min server memory (MB) and max server memory (MB) in this article.

https://free.blessedness.top/en-us/sql/database-engine/configure-windows/media/server-memory-server-configuration-options/configure-memory-in-ssms.png?view=sql-server-ver17#lightbox

The following query returns information about currently allocated memory.

SELECT physical_memory_in_use_kb / 1024 AS sql_physical_memory_in_use_MB,
       large_page_allocations_kb / 1024 AS sql_large_page_allocations_MB,
       locked_page_allocations_kb / 1024 AS sql_locked_page_allocations_MB,
       virtual_address_space_reserved_kb / 1024 AS sql_VAS_reserved_MB,
       virtual_address_space_committed_kb / 1024 AS sql_VAS_committed_MB,
       virtual_address_space_available_kb / 1024 AS sql_VAS_available_MB,
       page_fault_count AS sql_page_fault_count,
       memory_utilization_percentage AS sql_memory_utilization_percentage,
       process_physical_memory_low AS sql_process_physical_memory_low,
       process_virtual_memory_low AS sql_process_virtual_memory_low
FROM sys.dm_os_process_memory;

The following query returns information about the currently configured value and the value in use. This query returns results regardless of whether the sp_configure option 'show advanced options' is enabled.

SELECT [value], [value_in_use]
FROM sys.configurations
WHERE [name] = 'max server memory (MB)';