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.