Web Edition using 144 GB

• ps.

  One Orange Chip

  Points: 29422

  More actions

  October 28, 2019 at 3:40 pm

  #3692438

  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

  ---

  
  Pradeep Singh

• Site Owners

  SSC Guru

  Points: 80325

  More actions

  October 29, 2019 at 4:10 pm

  #3692809

  Thanks for posting your issue and hopefully someone will answer soon.

  This is an automated bump to increase visibility of your question.