App Domain is marked for unloaded due to memory pressure

Our SQL server 2005 is using sp2 (build 3042). Once in a while, the sql error log show alot of App Domain unloaded and App Domain created messages In between them, it also has App Domain is marked for Unloaded due to memory pressure, and more other messages will appear and indicate out of memory resources. When these happen, the CPU usually would be almost 100%. And constantly the cpu will be back to normally in about 20~30 minutes. My profiler shows that during the high CPU period, there were quite a few Assembly loading. We do use a trigger and assembly to call a CLR on quite a few commonly used tables. So the CLR call is often but not heavy. I would say maybe average 20 call per hour per table and we have about 5 tables using this trigger call to CLR.
I like to know what all these messages mean. Is this a code issue or bugs in SQL server? I checked the hot fixes after sp2 but didn't find a fix directly related to this problem but I may overlook. Please advice. Also, how can I track more detail about this problem in profiler or SQL 2005 dynamic system views in terms of what assembly is loading. Again the profiler only shows assembly loading but no details.
Any help on this is very much appreciated.
wingman

Check BOL
sys.dm_clr_appdomains
http://msdn2.microsoft.com/en-us/library/ms187720.aspx

Thank for the reply. I enclosed more detail info from the SQL error log. It is quite long. Please take a look. Our server has 6 Gbytes of RAM but snce os is Windows 2003 server standard so I allow SQL to use 3 Gbytes (Mim server memory: 1024 Max server memory: 3072). OS virtual memory is configurated as C drive 2 Gbytes and D drive 4 Gbytes. I like to know the errors we are seeing is code related or bug related. Am I running out of RAM? if there is a better SQL server memory configuration in terms of more Rams or settting changes in SQL memory option, please advise. 2008-04-02 11:43:23.22 spid1s AppDomain 29 (DBname1.dbo[runtime].28) is marked for unload due to memory pressure.
2008-04-02 11:43:23.22 spid1s AppDomain 29 (DBname1.dbo[runtime].28) unloaded.
2008-04-02 11:43:23.22 spid1s AppDomain 28 (DBname2.dbo[runtime].27) is marked for unload due to memory pressure.
2008-04-02 11:43:23.22 spid1s AppDomain 28 (DBname2.dbo[runtime].27) unloaded.
2008-04-02 11:43:23.22 spid1s AppDomain 27 (DBname3.dbo[runtime].26) is marked for unload due to memory pressure.
2008-04-02 11:43:23.22 spid1s AppDomain 27 (Dbname3.dbo[runtime].26) unloaded.
2008-04-02 11:43:25.80 spid165 AppDomain 30 (DBname4.dbo[runtime].29) created.
2008-04-02 11:43:33.50 spid1s AppDomain 30 (DBname4.dbo[runtime].29) is marked for unload due to memory pressure.
2008-04-02 11:43:33.50 spid1s AppDomain 30 (DBname4.dbo[runtime].29) unloaded.
2008-04-02 11:43:43.75 spid199 AppDomain 31 (DBname1.dbo[runtime].30) created.
2008-04-02 11:43:46.27 spid199 Error: 6533, Severity: 16, State: 49.
2008-04-02 11:43:46.27 spid199 AppDomain DBname1.dbo[runtime].30 was unloaded by escalation policy to ensure the consistency of your application. Out of memory happened while accessing a critical resource.
System.Threading.ThreadAbortException: Exception of type 'System.Threading.ThreadAbortException' was thrown.
System.Threading.ThreadAbortException:
2008-04-02 11:43:46.30 spid199 AppDomain 31 (DBname1.dbo[runtime].30) unloaded.
2008-04-02 11:44:05.63 spid249 Failed Virtual Allocate Bytes: FAIL_VIRTUAL_RESERVE 589824
2008-04-02 11:44:05.80 spid249
Memory Manager
VM Reserved = 2866356 KB
VM Committed = 129128 KB
AWE Allocated = 3151800 KB
Reserved Memory = 1024 KB
Reserved Memory In Use = 0 KB 2008-04-02 11:44:05.80 spid249
Memory node Id = 0
VM Reserved = 2862196 KB
VM Committed = 125120 KB
AWE Allocated = 3151800 KB
SinglePage Allocator = 188896 KB
MultiPage Allocator = 30080 KB 2008-04-02 11:44:05.80 spid249
MEMORYCLERK_SQLGENERAL (Total)
VM Reserved = 0 KB
VM Committed = 0 KB
AWE Allocated = 0 KB
SM Reserved = 0 KB
SM Committed = 0 KB
SinglePage Allocator = 58264 KB
MultiPage Allocator = 5496 KB2008-04-02 11:44:05.80 spid249
MEMORYCLERK_SQLBUFFERPOOL (Total)
VM Reserved = 2684332 KB
VM Committed = 32792 KB
AWE Allocated = 3151800 KB
SM Reserved = 0 KB
SM Committed = 0 KB
SinglePage Allocator = 0 KB
MultiPage Allocator = 1184 KB2008-04-02 11:44:05.80 spid249
MEMORYCLERK_SQLQUERYEXEC (Total)
VM Reserved = 0 KB
VM Committed = 0 KB
AWE Allocated = 0 KB
SM Reserved = 0 KB
SM Committed = 0 KB
SinglePage Allocator = 18632 KB
MultiPage Allocator = 520 KB2008-04-02 11:44:05.80 spid249
MEMORYCLERK_SQLOPTIMIZER (Total)
VM Reserved = 0 KB
VM Committed = 0 KB
AWE Allocated = 0 KB
SM Reserved = 0 KB
SM Committed = 0 KB
SinglePage Allocator = 22736 KB
MultiPage Allocator = 72 KB2008-04-02 11:44:05.80 spid249
MEMORYCLERK_SQLUTILITIES (Total)
VM Reserved = 840 KB
VM Committed = 840 KB
AWE Allocated = 0 KB
SM Reserved = 0 KB
SM Committed = 0 KB
SinglePage Allocator = 26608 KB
MultiPage Allocator = 7776 KB2008-04-02 11:44:05.80 spid249
MEMORYCLERK_SQLSTORENG (Total)
VM Reserved = 12096 KB
VM Committed = 12096 KB
AWE Allocated = 0 KB
SM Reserved = 0 KB
SM Committed = 0 KB
SinglePage Allocator = 6752 KB
MultiPage Allocator = 328 KB2008-04-02 11:44:05.80 spid249
MEMORYCLERK_SQLCONNECTIONPOOL (Total)
VM Reserved = 0 KB
VM Committed = 0 KB
AWE Allocated = 0 KB
SM Reserved = 0 KB
SM Committed = 0 KB
SinglePage Allocator = 4632 KB
MultiPage Allocator = 0 KB2008-04-02 11:44:05.80 spid249
MEMORYCLERK_SQLCLR (Total)
VM Reserved = 122176 KB
VM Committed = 39472 KB
AWE Allocated = 0 KB
SM Reserved = 0 KB
SM Committed = 0 KB
SinglePage Allocator = 1136 KB
MultiPage Allocator = 7656 KB2008-04-02 11:44:05.80 spid249
MEMORYCLERK_SQLSERVICEBROKER (Total)
VM Reserved = 0 KB
VM Committed = 0 KB
AWE Allocated = 0 KB
SM Reserved = 0 KB
SM Committed = 0 KB
SinglePage Allocator = 120 KB
MultiPage Allocator = 192 KB2008-04-02 11:44:05.80 spid249
MEMORYCLERK_SQLHTTP (Total)
VM Reserved = 0 KB
VM Committed = 0 KB
AWE Allocated = 0 KB
SM Reserved = 0 KB
SM Committed = 0 KB
SinglePage Allocator = 8 KB
MultiPage Allocator = 0 KB2008-04-02 11:44:05.80 spid249
MEMORYCLERK_SNI (Total)
VM Reserved = 0 KB
VM Committed = 0 KB
AWE Allocated = 0 KB
SM Reserved = 0 KB
SM Committed = 0 KB
SinglePage Allocator = 296 KB
MultiPage Allocator = 16 KB2008-04-02 11:44:05.80 spid249
MEMORYCLERK_FULLTEXT (Total)
VM Reserved = 0 KB
VM Committed = 0 KB
AWE Allocated = 0 KB
SM Reserved = 0 KB
SM Committed = 0 KB
SinglePage Allocator = 16 KB
MultiPage Allocator = 0 KB2008-04-02 11:44:05.80 spid249
MEMORYCLERK_SQLXP (Total)
VM Reserved = 0 KB
VM Committed = 0 KB
AWE Allocated = 0 KB
SM Reserved = 0 KB
SM Committed = 0 KB
SinglePage Allocator = 16 KB
MultiPage Allocator = 0 KB2008-04-02 11:44:05.80 spid249
MEMORYCLERK_QSRANGEPREFETCH (Total)
VM Reserved = 0 KB
VM Committed = 0 KB
AWE Allocated = 0 KB
SM Reserved = 0 KB
SM Committed = 0 KB
SinglePage Allocator = 40 KB
MultiPage Allocator = 0 KB2008-04-02 11:44:05.80 spid249
MEMORYCLERK_BHF (Total)
VM Reserved = 0 KB
VM Committed = 0 KB
AWE Allocated = 0 KB
SM Reserved = 0 KB
SM Committed = 0 KB
SinglePage Allocator = 2064 KB
MultiPage Allocator = 0 KB2008-04-02 11:44:05.80 spid249
MEMORYCLERK_SQLQERESERVATIONS (Total)
VM Reserved = 0 KB
VM Committed = 0 KB
AWE Allocated = 0 KB
SM Reserved = 0 KB
SM Committed = 0 KB
SinglePage Allocator = 1159968 KB
MultiPage Allocator = 0 KB2008-04-02 11:44:05.80 spid249
MEMORYCLERK_HOST (Total)
VM Reserved = 0 KB
VM Committed = 0 KB
AWE Allocated = 0 KB
SM Reserved = 0 KB
SM Committed = 0 KB
SinglePage Allocator = 80 KB
MultiPage Allocator = 64 KB2008-04-02 11:44:05.80 spid249
MEMORYCLERK_SOSNODE (Total)
VM Reserved = 0 KB
VM Committed = 0 KB
AWE Allocated = 0 KB
SM Reserved = 0 KB
SM Committed = 0 KB
SinglePage Allocator = 13056 KB
MultiPage Allocator = 6464 KB2008-04-02 11:44:05.80 spid249
MEMORYCLERK_SQLSERVICEBROKERTRANSPORT (Total)
VM Reserved = 0 KB
VM Committed = 0 KB
AWE Allocated = 0 KB
SM Reserved = 0 KB
SM Committed = 0 KB
SinglePage Allocator = 48 KB
MultiPage Allocator = 0 KB2008-04-02 11:44:05.80 spid249
CACHESTORE_OBJCP (Total)
VM Reserved = 0 KB
VM Committed = 0 KB
AWE Allocated = 0 KB
SM Reserved = 0 KB
SM Committed = 0 KB
SinglePage Allocator = 2160 KB
MultiPage Allocator = 0 KB2008-04-02 11:44:05.80 spid249
CACHESTORE_SQLCP (Total)
VM Reserved = 0 KB
VM Committed = 0 KB
AWE Allocated = 0 KB
SM Reserved = 0 KB
SM Committed = 0 KB
SinglePage Allocator = 3392 KB
MultiPage Allocator = 0 KB2008-04-02 11:44:05.80 spid249
CACHESTORE_PHDR (Total)
VM Reserved = 0 KB
VM Committed = 0 KB
AWE Allocated = 0 KB
SM Reserved = 0 KB
SM Committed = 0 KB
SinglePage Allocator = 5184 KB
MultiPage Allocator = 0 KB2008-04-02 11:44:05.80 spid249
CACHESTORE_XPROC (Total)
VM Reserved = 0 KB
VM Committed = 0 KB
AWE Allocated = 0 KB
SM Reserved = 0 KB
SM Committed = 0 KB
SinglePage Allocator = 40 KB
MultiPage Allocator = 0 KB2008-04-02 11:44:05.80 spid249
CACHESTORE_TEMPTABLES (Total)
VM Reserved = 0 KB
VM Committed = 0 KB
AWE Allocated = 0 KB
SM Reserved = 0 KB
SM Committed = 0 KB
SinglePage Allocator = 48 KB
MultiPage Allocator = 0 KB2008-04-02 11:44:05.80 spid249
CACHESTORE_NOTIF (Total)
VM Reserved = 0 KB
VM Committed = 0 KB
AWE Allocated = 0 KB
SM Reserved = 0 KB
SM Committed = 0 KB
SinglePage Allocator = 16 KB
MultiPage Allocator = 0 KB2008-04-02 11:44:05.80 spid249
CACHESTORE_VIEWDEFINITIONS (Total)
VM Reserved = 0 KB
VM Committed = 0 KB
AWE Allocated = 0 KB
SM Reserved = 0 KB
SM Committed = 0 KB
SinglePage Allocator = 16 KB
MultiPage Allocator = 0 KB2008-04-02 11:44:05.80 spid249
CACHESTORE_XMLDBTYPE (Total)
VM Reserved = 0 KB
VM Committed = 0 KB
AWE Allocated = 0 KB
SM Reserved = 0 KB
SM Committed = 0 KB
SinglePage Allocator = 8 KB
MultiPage Allocator = 0 KB2008-04-02 11:44:05.80 spid249
CACHESTORE_XMLDBELEMENT (Total)
VM Reserved = 0 KB
VM Committed = 0 KB
AWE Allocated = 0 KB
SM Reserved = 0 KB
SM Committed = 0 KB
SinglePage Allocator = 8 KB
MultiPage Allocator = 0 KB2008-04-02 11:44:05.80 spid249
CACHESTORE_XMLDBATTRIBUTE (Total)
VM Reserved = 0 KB
VM Committed = 0 KB
AWE Allocated = 0 KB
SM Reserved = 0 KB
SM Committed = 0 KB
SinglePage Allocator = 8 KB
MultiPage Allocator = 0 KB2008-04-02 11:44:05.80 spid249
CACHESTORE_STACKFRAMES (Total)
VM Reserved = 0 KB
VM Committed = 0 KB
AWE Allocated = 0 KB
SM Reserved = 0 KB
SM Committed = 0 KB
SinglePage Allocator = 0 KB
MultiPage Allocator = 8 KB2008-04-02 11:44:05.80 spid249
CACHESTORE_BROKERTBLACS (Total)
VM Reserved = 0 KB
VM Committed = 0 KB
AWE Allocated = 0 KB
SM Reserved = 0 KB
SM Committed = 0 KB
SinglePage Allocator = 272 KB
MultiPage Allocator = 0 KB2008-04-02 11:44:05.80 spid249
CACHESTORE_BROKERKEK (Total)
VM Reserved = 0 KB
VM Committed = 0 KB
AWE Allocated = 0 KB
SM Reserved = 0 KB
SM Committed = 0 KB
SinglePage Allocator = 8 KB
MultiPage Allocator = 0 KB2008-04-02 11:44:05.80 spid249
CACHESTORE_BROKERDSH (Total)
VM Reserved = 0 KB
VM Committed = 0 KB
AWE Allocated = 0 KB
SM Reserved = 0 KB
SM Committed = 0 KB
SinglePage Allocator = 8 KB
MultiPage Allocator = 0 KB2008-04-02 11:44:05.80 spid249
CACHESTORE_BROKERUSERCERTLOOKUP (Total)
VM Reserved = 0 KB
VM Committed = 0 KB
AWE Allocated = 0 KB
SM Reserved = 0 KB
SM Committed = 0 KB
SinglePage Allocator = 8 KB
MultiPage Allocator = 0 KB2008-04-02 11:44:05.80 spid249
CACHESTORE_BROKERRSB (Total)
VM Reserved = 0 KB
VM Committed = 0 KB
AWE Allocated = 0 KB
SM Reserved = 0 KB
SM Committed = 0 KB
SinglePage Allocator = 8 KB
MultiPage Allocator = 0 KB2008-04-02 11:44:05.80 spid249
CACHESTORE_BROKERREADONLY (Total)
VM Reserved = 0 KB
VM Committed = 0 KB
AWE Allocated = 0 KB
SM Reserved = 0 KB
SM Committed = 0 KB
SinglePage Allocator = 32 KB
MultiPage Allocator = 0 KB2008-04-02 11:44:05.80 spid249
CACHESTORE_BROKERTO (Total)
VM Reserved = 0 KB
VM Committed = 0 KB
AWE Allocated = 0 KB
SM Reserved = 0 KB
SM Committed = 0 KB
SinglePage Allocator = 8 KB
MultiPage Allocator = 0 KB2008-04-02 11:44:05.80 spid249
CACHESTORE_EVENTS (Total)
VM Reserved = 0 KB
VM Committed = 0 KB
AWE Allocated = 0 KB
SM Reserved = 0 KB
SM Committed = 0 KB
SinglePage Allocator = 16 KB
MultiPage Allocator = 0 KB2008-04-02 11:44:05.80 spid249
CACHESTORE_SYSTEMROWSET (Total)
VM Reserved = 0 KB
VM Committed = 0 KB
AWE Allocated = 0 KB
SM Reserved = 0 KB
SM Committed = 0 KB
SinglePage Allocator = 608 KB
MultiPage Allocator = 0 KB2008-04-02 11:44:05.80 spid249
USERSTORE_SCHEMAMGR (Total)
VM Reserved = 0 KB
VM Committed = 0 KB
AWE Allocated = 0 KB
SM Reserved = 0 KB
SM Committed = 0 KB
SinglePage Allocator = 9360 KB
MultiPage Allocator = 0 KB2008-04-02 11:44:05.80 spid249
USERSTORE_DBMETADATA (Total)
VM Reserved = 0 KB
VM Committed = 0 KB
AWE Allocated = 0 KB
SM Reserved = 0 KB
SM Committed = 0 KB
SinglePage Allocator = 2104 KB
MultiPage Allocator = 0 KB2008-04-02 11:44:05.80 spid249
USERSTORE_TOKENPERM (Total)
VM Reserved = 0 KB
VM Committed = 0 KB
AWE Allocated = 0 KB
SM Reserved = 0 KB
SM Committed = 0 KB
SinglePage Allocator = 2712 KB
MultiPage Allocator = 0 KB2008-04-02 11:44:05.80 spid249
USERSTORE_OBJPERM (Total)
VM Reserved = 0 KB
VM Committed = 0 KB
AWE Allocated = 0 KB
SM Reserved = 0 KB
SM Committed = 0 KB
SinglePage Allocator = 1136 KB
MultiPage Allocator = 24 KB2008-04-02 11:44:05.80 spid249
USERSTORE_SXC (Total)
VM Reserved = 0 KB
VM Committed = 0 KB
AWE Allocated = 0 KB
SM Reserved = 0 KB
SM Committed = 0 KB
SinglePage Allocator = 160 KB
MultiPage Allocator = 0 KB2008-04-02 11:44:05.80 spid249
OBJECTSTORE_LBSS (Total)
VM Reserved = 0 KB
VM Committed = 0 KB
AWE Allocated = 0 KB
SM Reserved = 0 KB
SM Committed = 0 KB
SinglePage Allocator = 320 KB
MultiPage Allocator = 0 KB2008-04-02 11:44:05.80 spid249
OBJECTSTORE_SNI_PACKET (Total)
VM Reserved = 0 KB
VM Committed = 0 KB
AWE Allocated = 0 KB
SM Reserved = 0 KB
SM Committed = 0 KB
SinglePage Allocator = 5096 KB
MultiPage Allocator = 144 KB2008-04-02 11:44:05.80 spid249
OBJECTSTORE_SERVICE_BROKER (Total)
VM Reserved = 0 KB
VM Committed = 0 KB
AWE Allocated = 0 KB
SM Reserved = 0 KB
SM Committed = 0 KB
SinglePage Allocator = 256 KB
MultiPage Allocator = 0 KB2008-04-02 11:44:05.80 spid249
OBJECTSTORE_LOCK_MANAGER (Total)
VM Reserved = 8192 KB
VM Committed = 8192 KB
AWE Allocated = 0 KB
SM Reserved = 0 KB
SM Committed = 0 KB
SinglePage Allocator = 1368 KB
MultiPage Allocator = 0 KB2008-04-02 11:44:05.80 spid249 Buffer Distribution: Stolen=28825 Free=160612 Cached=3684
Database (clean)=196916 Database (dirty)=3124
I/O=1, Latched=542008-04-02 11:44:05.80 spid249 Buffer Counts: Committed=393216 Target=393216 Hashed=200105
Internal Reservation=66150 External Reservation=136108
Stolen Potential=145584
Min Free=160 Visible=330752
Available Paging File=6620639232
2008-04-02 11:44:05.80 spid249 Procedure Cache: TotalProcs=29 TotalPages=1347 InUsePages=3062008-04-02 11:44:05.80 spid249 Process physical/virtual memory pressure: 0/0 System physical memory pressure: 02008-04-02 11:44:05.80 spid249 Global Memory Objects:
Resource= 738
Locks= 174
SE Schema Mgr= 1169
SQLCache= 6186
Replication= 348
ServerGlobal= 28
XPGlobal= 2
Xact= 161
SETLS= 4
DatasetMemObjs= 8
SubpDescPmos= 28
SortTables= 22008-04-02 11:44:05.80 spid249 Query Memory Objects: Grants=7 Waiting=0 Maximum=236109 Available=91113 Limit=2361092008-04-02 11:44:05.80 spid249 Query Memory Objects: Next Request=0 Waiting For=0 Cost=0 Timeout=0 Wait Time=0 Last Target=2485352008-04-02 11:44:05.80 spid249 Small Query Memory Objects: Grants=0 Waiting=0 Maximum=12426 Available=12426 Limit=124262008-04-02 11:44:05.80 spid249
Optimization Queue
Overall Memory = 2171805696 Target Memory = 1262149632 Last Notification = GROW Timeout = 6 Early Termination Factor = 5
2008-04-02 11:44:05.80 spid249
Small Gateway
Configured Units = 16 Available Units = 0 Acquires = 16
Waiters = 4 Threshold Factor = 250000 Threshold = 250000
2008-04-02 11:44:05.80 spid249
Medium Gateway
Configured Units = 4 Available Units = 4 Acquires = 0
Waiters = 0 Threshold Factor = 12 Threshold = 6573696
2008-04-02 11:44:05.80 spid249
Big Gateway
Configured Units = 1 Available Units = 1 Acquires = 0
Waiters = 0 Threshold Factor = 8 Threshold = -1
2008-04-02 11:44:05.80 spid249
MEMORYBROKER_FOR_CACHE
Allocations = 3681
Rate = 279
Target Allocations = 137339
Future Allocations = 0
Last Notification = GROW 2008-04-02 11:44:05.80 spid249
MEMORYBROKER_FOR_STEAL
Allocations = 19939
Rate = 753
Target Allocations = 154071
Future Allocations = 0
Last Notification = GROW 2008-04-02 11:44:05.80 spid249
MEMORYBROKER_FOR_RESERVE
Allocations = 145316
Rate = 10867
Target Allocations = 265113
Future Allocations = 59027
Last Notification = GROW 2008-04-02 11:44:05.82 spid249 Error: 701, Severity: 17, State: 123.
2008-04-02 11:44:05.82 spid249 There is insufficient system memory to run this query.
2008-04-02 11:44:11.24 spid249 Error: 701, Severity: 17, State: 123.
2008-04-02 11:44:11.24 spid249 There is insufficient system memory to run this query.
2008-04-02 11:44:14.90 spid249 Error: 701, Severity: 17, State: 123.
2008-04-02 11:44:14.90 spid249 There is insufficient system memory to run this query.
2008-04-02 11:44:41.49 spid115 AppDomain 32 (DBname1.dbo[runtime].31) created.
2008-04-02 11:44:43.05 spid115 Error: 6533, Severity: 16, State: 49.
2008-04-02 11:44:43.05 spid115 AppDomain DBname1.dbo[runtime].31 was unloaded by escalation policy to ensure the consistency of your application. Out of memory happened while accessing a critical resource.
System.Threading.ThreadAbortException: Exception of type 'System.Threading.ThreadAbortException' was thrown.
System.Threading.ThreadAbortException:
2008-04-02 11:44:43.07 spid115 AppDomain 32 (DBname1.dbo[runtime].31) unloaded.
2008-04-02 11:45:05.49 spid160 Error: 701, Severity: 17, State: 123.
2008-04-02 11:45:05.49 spid160 There is insufficient system memory to run this query.
2008-04-02 11:45:10.93 spid160 Error: 701, Severity: 17, State: 123.
2008-04-02 11:45:10.93 spid160 There is insufficient system memory to run this query.
2008-04-02 11:45:14.72 spid160 Error: 701, Severity: 17, State: 123.
2008-04-02 11:45:14.72 spid160 There is insufficient system memory to run this query.
2008-04-02 11:45:25.24 spid272 Downgrading backup log buffers from 1024K to 64K
2008-04-02 11:45:29.16 Backup Log was backed up. Database: DBname1, creation date(time): 2007/05/06(03:52:06), first LSN: 36962:65950:1, last LSN: 36962:91785:1, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'d:SQLbkupDBname1_20080402164519.trn'}). This is an informational message only. No user action is required.
2008-04-02 11:46:05.71 spid98 Error: 701, Severity: 17, State: 123.
2008-04-02 11:46:05.71 spid98 There is insufficient system memory to run this query.
2008-04-02 11:46:11.33 spid98 Error: 701, Severity: 17, State: 123.
2008-04-02 11:46:11.33 spid98 There is insufficient system memory to run this query.
2008-04-02 11:46:15.16 spid98 Error: 701, Severity: 17, State: 123.
2008-04-02 11:46:15.16 spid98 There is insufficient system memory to run this query.
2008-04-02 11:47:07.43 spid287 AppDomain 33 (DBname1.dbo[runtime].32) created.
2008-04-02 11:47:09.08 spid287 Error: 6533, Severity: 16, State: 49.
2008-04-02 11:47:09.08 spid287 AppDomain DBname1.dbo[runtime].32 was unloaded by escalation policy to ensure the consistency of your application. Out of memory happened while accessing a critical resource.
System.Threading.ThreadAbortException: Exception of type 'System.Threading.ThreadAbortException' was thrown.
System.Threading.ThreadAbortException:
………………………………………..