Dear Experts,
I'm trying to figure out if my SQL server is facing any memory pressure . Its a 64 GB memory server with one SQL instance with 50 B max memory. Though the buffer usage stats show that all the databases put together use up around 42 GB , the task manager shows a usage of 56 GB . This is server is dedicated for one instance of SQL server with 7 databases , only one of them (it uses 34 GB) is most crucial and much bigger than the others . Not sure what is consuming the additional memory .Any comments on this ? Thank you.
SQL Server will do its damnedest to pre-allocate all of the memory that it has been allowed to use. Its not an indication of memory pressure for it to do so.
I didn't think that was the case. That is, that SQL will acquire additional memory for buffers only when it needs it, not simply because its max memory allows it to.
A more fair statement might be that SQL Server will grab memory as needed but do it's damnedest never to give it up once taken 😛