Hi, we have a sql server 2016 web edition. I noticed memory usage is more than 95% on the server. we have 2 instances, one of which is using 144 GB. This seems quite high as the limitation is of 64 GB buffer pool plus overheads.
Here are the usage of the top 2 components. Is usage by the 2nd component normal? Also, these 2 together constitutes about 87 GB and i am unable to find which component is using remaining 144-87 = 57 GB. Can someone pls help me track this down?
MEMORYCLERK_SQLBUFFERPOOL 65544
MEMORYCLERK_SQLQERESERVATIONS 21456