SSISDB.dbo[runtime].x) is marked for unload due to memory pressure

Question

Hi,

We are running SQL Server 2016 on Windows Server 2016. There are 16GB RAM. Maximum SQL Server Memory is set to 12GB.

Consultant says that the application server connection to Database Server is somehow lost and asks us to look into the SQL Server Error Log. However, we cannot find any related error message.

On the other hand, we find that there are a number of SSISDB Error
SSISDB.dbo[runtime].x) is marked for unload due to memory pressure

We find that that error message happens at 2 particular time

1. When we start daily backup OR
2. When daily backup finishes / SSIS Rebuild task finishes

However, we find that both SQL Server Backup and SSIS Tasks run successfully every night.

May I ask

1. What is the potential problem for those error messages ?
2. Is it necessary for us to increase the Server RAM or SSIS Buffer Size ?
3. Would it causes connection problem between Database Server and Application Server ?

Thanks

Answer 1

Consultant says that the application server connection to Database Server is somehow lost

Is lost? What does that mean in detail?

SSISDB.dbo[runtime].x) is marked for unload due to memory pressure

SSIS uses some CLR and on memory preasure the runtime get's unload; happens on my servers too (which ist an information message, not an error!) and that never caused any issue.
If the CLR is accessed later, it will be loaded again an you get an info message like "AppDomain 253 (master.sys[runtime].253) created."

Would it causes connection problem between Database Server and Application Server ?

No,

Is it necessary for us to increase the Server RAM

More RAM is never wrong, SQL Server highly use it.