SQL Server - AppDomain is marked for unload due to memory pressure

17 January,2013 by Jack Vamvas

On SQL Server Error Log messages I see this error message relating to memory pressure:

AppDomain xxxxxxxxxxxxxxxx is marked for unload due to memory pressure.
AppDomain xxxxxxxxxxxxxxxx is marked for unload due to common language runtime (CLR) or security data definition language (DDL) operations.

 

Some important points to consider:

1) SQLCLR runs in the SQLOS in limited memory space called MemToLeave.A number of processes run inside the MemToLeave – such as OLE automation and 3rd party backup applications. For a comprehensive list check: SQL server OLE Automation memory pressure - SQL Server DBA

2) Investigate other applications running on the server. Huge memory bottlenecks can occur with external applications on the server.

3) Look at server memory and SQL Server memory. Is there enough memory?

4) Use these Views for informations on assemblies and application domains on the server

sys.assemblies
sys.dm_clr_appdomains
sys.dm_clr_loaded_assemblies

5) Watch the memory problem on:

select * from sys.dm_os_memory_clerks where type = 'MEMORYCLERK_SQLCLR'

 Read More

SQL Server Performance ,memory pressure and memory usage

SQL Server – Memory leak detection - SQL Server DBA

SQL Server – Troubleshoot memory pressure with Default Trace and Server Memory Change event class

SQL Server – Measuring SQL memory usage - SQL Server DBA

 


Author: Jack Vamvas (http://www.sqlserver-dba.com)


Share:

Verify your Comment

Previewing your Comment

This is only a preview. Your comment has not yet been posted.

Working...
Your comment could not be posted. Error type:
Your comment has been posted. Post another comment

The letters and numbers you entered did not match the image. Please try again.

As a final step before posting your comment, enter the letters and numbers you see in the image below. This prevents automated programs from posting comments.

Having trouble reading this image? View an alternate.

Working...

Post a comment on SQL Server - AppDomain is marked for unload due to memory pressure


sqlserver-dba.com | SQL Server Performance Tuning | SQL Server DBA:Everything | FAQ | Contact|Copyright & Disclaimer