SQLTeam.com | Weblogs | Forums

AppDomain unload, CLR, Max Server Memory


#1

Please help...

I am running SQL 2016 on Windows 10.

I have numerous messages like the following in the ErrorLog:
AppDomain 16471 ([MyDBName].dbo[runtime].16851) is marked for unload due to memory pressure.

Physical RAM: 170GB
Max Server Memory: 158GB

As I understand, beginning in SQL 2012, SQL CLR is now included in the buffer pool, and is a part of Max Server Memory.

Therefore, if the assumption that the CLR's are written optimally, the way to attack this memory pressure would be to increase Max Server Memory, changing from 158GB to 160GB. Correct?