question

IJ5569 avatar image
IJ5569 asked

Is memory for CLR SSIS module included in the memory reserved for SQL Server 2017?

I have many issues like this in my SQL Server 2017:


Mensaje AppDomain 16 (SSISDB.dbo[runtime].26) is marked for unload due to memory >pressure.


Should I increase or reduce the "max memory" parameter?

More generally, is the memory for CLR SSIS module included in the memory reserved for SQL Server?

Thanks in advance,


ssissql-serverclrmemory-utilization
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
srutzky avatar image
srutzky answered

Starting in SQL Server 2012, SQLCLR memory became controlled by the min / max memory settings:

Memory configuration and sizing considerations in SQL Server 2012 and later versions


So, you should at least try increasing "max server memory" to see if that helps. Just keep in mind that you still might see the occasional message about an AppDomain being unloaded due to memory pressure. However, hopefully you see such messages less often.

10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.