SQL Buffer pool is consuming more memory in sql server 2017. Is there any way to reduce it?? or How can we find what is consuming more? We are receiving alert for low buffer cache hit ratio. MEMORYCLERK_SQLBUFFERPOOL 90365.62 MB
One particular database alone consuming 87GB buffer pool. Total memory allocated to this instance is 100GB