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

TonyJK 876 Reputation points
2022-09-06T02:04:47.147+00:00

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

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,653 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,451 questions
0 comments No comments
{count} votes

Accepted answer
  1. Olaf Helper 40,656 Reputation points
    2022-09-06T06:19:03.71+00:00

    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.

    0 comments No comments

0 additional answers

Sort by: Most helpful