'MS sql server memory pressure occurs in logs
We have SQL Server 2016 running on Windows 2016 datacenter edition with 64 GB ram (for SQL we have allocated 59 GB).
For the past month we have checked in logs following error like appdomain unloaded due to memory pressure.
Logs:
1.Date 5/24/2022 3:36:02 PM Log SQL Server (Current - 5/24/2022 11:10:00 AM)
Source spid2893
Message Unsafe assembly 'crystal.license.sql.service, version=0.0.0.0, culture=neutral, publickeytoken=null, processorarchitecture=msil' loaded into appdomain 182666 (Petrus_WalletHR.dbo[runtime].184090). 2. Date 5/24/2022 3:36:02 PM Log SQL Server (Current - 5/24/2022 11:10:00 AM)
Source spid2893
Message AppDomain 182666 (Petrus_WalletHR.dbo[runtime].184090) created. 3.Date 5/24/2022 3:36:02 PM Log SQL Server (Current - 5/24/2022 11:10:00 AM)
Source spid32s
Message AppDomain 182664 (Nexus_WalletHR.dbo[runtime].184088) unloaded. 4.Date 5/24/2022 3:36:02 PM Log SQL Server (Current - 5/24/2022 11:10:00 AM)
Source spid21s
Message AppDomain 182664 (Nexus_WalletHR.dbo[runtime].184088) is marked for unload due to memory pressure.
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|

