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.
Ugh! My apologies for the bad info and I stand corrected. I'm not sure why I used the word "pre-allocate" because that's definitely incorrect.