SQL releasing memory while there is free memory to use.

• John Tracy-374327

  Valued Member

  Points: 68

  More actions

  September 16, 2013 at 7:31 am

  #283209

  All,

  We had a situation on one of our production servers today. The max memory is set to 110 GB. At a certain point the SQL Process started to release memory and got all the way down to 50 GB. At this point it started to have performance problems for the application hooked up to it. IT also threw an error like this in the log: AppDomain 6 (mssqlsystemresource.dbo[runtime].5) is marked for unload due to memory pressure.

  During this period of time, about an hour the CPU level went very high. IT stayed high as the memory consumption gradually grew again. I eventually cleared the procedure cache and the CPU came down.

  During this period of time there was not memory pressure from any other applicaiton -- the free memory was increasing as the amount of memory sql was using decreased.

  I have checked windows event logs and sql errorlogs and find nothing.

  Has anyone seen this before? Any ideas on why this happened?

  Thanks

  John Tracy