Following a previous post I've written, I've configured my server with the following parameters:
I put 22497 as MAx Server Memory, disable AWE, since it runs in 64 bit environment and it's a production server.
During a reboot, it starts from the min configuration, and slowly increase memory consumption until almost midnight that reaches the max memory configuration.
Until then if I monitor memory consumption, the task manager reports that memory increases to 25 GB of RAM. Yesterday we removed AWE, reboot the instance, and it started slowly increasing memory Until around 17:00pm , it was using almost 25.2 GB of RAM:
Today after a reboot, it is now using 11GB.
I now, that in a previous post said this memory consumption is "Normal Behaviour" of SQL Server, but why it suddenly use more of the max memory I set as maximum? UPDATE 2021-03-31:
As for Today March 31, 2021 08:09AM, my server is using 25.3 GB of RAM:
Using Aleksey Script This are the numbers SQL Reports is using:
Resource Monitor says SQL Server IS using all the RAM:
Yesterday at 17:00 it was using 13 GB
And this is the behaviour of the server, That's why I'm asking if this is normal or not, what is making the server use 25.3 GB if it's limit should be 22.5 GB (rounded per my calculations). This is the issue.
I know Microsofts literature says a lot of stuff, but I haven't get a clue of why this behaviour, I've already check Stored Procedures, Indexes, Jobs, etc.. and I don't see what is making the SQL Server use more of the assigned maximum server memory.
I disabled AWE, since this instance is running in a Virtual Machine in Hyper V, 64 bit Environment, (Windows 2008 R2 64 Bit, Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (X64) Apr 2 2010 15:48:46 Copyright (c) Microsoft Corporation Enterprise Edition (64-bit) on Windows NT 6.1 (Build 7601: Service Pack 1) (Hypervisor) and I can't figure what's going on with this behaviour.