SQL Server Performance

App Domain is marked for unloaded due to memory pressure

Discussion in 'SQL Server 2005 CLR' started by WingSzeto, Apr 4, 2008.

  1. WingSzeto Member

    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
  2. MohammedU New Member

  3. WingSzeto Member

    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:
    ………………………………………..

Share This Page