September 20, 2010 at 5:10 am
I get this error from SQL Server 2005.this machine is 64 bit.
"AppDomain <ApplicationDomain> is marked for unload due to memory pressure"
sqlserver.exe restarts every now and then after allocating memory up to 1,6GB (8 GB availible) and then increasing CPU load up to near 100 %.
Eventlog:
6299 - AppDomain 11 (SMS_G01.dbo[runtime].12) created.
6290 - AppDomain 11 (SMS_G01.dbo[runtime].12) unloaded.
10311 - AppDomain 11 (SMS_G01.dbo[runtime].12) is marked for unload due to memory pressure.
SQL-Serverlog:19/09/2010 16:29:50,spid74,Unknown,AppDomain 9 (SMS_G01.dbo[runtime].10) created.
19/09/2010 16:29:11,spid1s,Unknown,AppDomain 8 (SMS_G01.dbo[runtime].9) unloaded.
19/09/2010 16:29:11,spid1s,Unknown,AppDomain 8 (SMS_G01.dbo[runtime].9) is marked for unload due to memory pressure.
19/09/2010 16:29:11,spid1s,Unknown,A significant part of sql server process memory has been paged out. This may result in a performance degradation. Duration: 0 seconds. Working set (KB): 47892<c/> committed (KB): 1665388<c/> memory utilization: 2%.
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
September 20, 2010 at 6:12 am
You may find this article useful.
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
September 20, 2010 at 6:48 am
Adiga (9/20/2010)
You may find this article useful.
Thanks but as i mentioned that i have 64 bit machine and this resolution is for 32 bit machine.
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply