"... is marked for unload due to memory pressure" - is that a big problem?

• jankovic

  Old Hand

  Points: 333

  More actions

  August 19, 2021 at 9:07 am

  #3921648

  I've got a mixed server on which SSIS is being used and I got notification about memory pressure and memory pages/sec.

  I got following messages in my log

  AppDomain 67 (SSISDB.dbo[runtime].66) is marked for unload due to memory pressure.

  However I am not sure what the impact is here as SSIS jobs is succeeding. Here's how it plays out:

  1. So at 3:00 AM job is executed:Message

     AppDomain 67 (SSISDB.dbo[runtime].66) created.

  2.  Job is started at 3:00:21 AM
  3. At 3:20:20 AM I got this message:AppDomain 67 (SSISDB.dbo[runtime].66) is marked for unload due to memory pressure.

     Immedietely followed by this one:

     AppDomain 67 (SSISDB.dbo[runtime].66) unloaded.

  4. Job is successfully finished at 3:21:06 AM

  I don't fully understand what unloaded means, but from what I read it means process memory was freed.

  But how it completed successfully in this case?

   

  Total server memory is 16GB

  SQL Server maximum is 7168MB

  Wouldn't process got interrupted?

   

   

   

   

  • This topic was modified 3 years, 3 months ago by  jankovic. Reason: add memory config info

• Site Owners

  SSC Guru

  Points: 80330

  More actions

  August 20, 2021 at 9:10 am

  #3922036

  Thanks for posting your issue and hopefully someone will answer soon.

  This is an automated bump to increase visibility of your question.