SQL Server Max Memory not being respected Azure VM

John Puttman 1 Reputation point
2019-12-06T14:03:53.033+00:00

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
Azure Virtual Machines
An Azure service that is used to provision Windows and Linux virtual machines.
7,159 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Daniel Powell 1 Reputation point
    2020-02-04T23:36:08.253+00:00

    @John Puttman have you stopped and restarted the instance? Memory limiting is only observed after restarting

    0 comments