question

JohnPuttman-1201 avatar image
0 Votes"
JohnPuttman-1201 asked ·

SQL Server Max Memory not being respected Azure VM

I have an Azure VM - Standard DS14 v2 (16 vcpus, 112 GiB memory) - That is used to run one instance of SQL Server. The Max Memory for this instance is set at 100,000 MB. The target memory in perfmon is around 110 GB and the total memory is 80 GB. I am not sure what configuration to change to ensure that the 100 GB of memory configured for max is respected.

This chart show about 10 days worth of perfmon data at a 30 second collection interval. alt text


azure-virtual-machines
2019-12-06-05-13-07-perfmon-analysis-power-bi-desk.png (24.4 KiB)
10 |1000 characters needed characters left characters exceeded
Toggle Comment visibility. Current Visibility: Visible to all users

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

DanielJPowell avatar image
0 Votes"
DanielJPowell answered ·

@JohnPuttman-1201 have you stopped and restarted the instance? Memory limiting is only observed after restarting

·
10 |1000 characters needed characters left characters exceeded
Toggle Comment visibility. Current Visibility: Visible to all users

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.