Intrebari generale

Re: SQL Server 2005 CLR marked for unload due to memory pressure error

xmldeveloper — Fri, 19 Mar 2010 14:05:13 GMT

Daca nu este aplicat nici un Service Pack atunci poti verifica si urmatoarele articole de suport:

FIX: Error message when you run a SQL Server 2005 application that contains user-defined data types: "AppDomain 3 (<db_name>.dbo[runtime].2) is marked for unload due to memory pressure"
FIX: You may receive an error message when you run a CLR stored procedure or CLR function that uses a context connection in SQL Server 2005

Pentru CLR codding best practices: The Database Administrator’s Guide to the SQL Server Database Engine .NET Common Language Runtime Environment

Re: SQL Server 2005 CLR marked for unload due to memory pressure error

MrSmersh — Tue, 23 Feb 2010 22:34:43 GMT

Danke!
Inca mai citesc, dar macar am o directie.
Si daca nu inteleg ceva intreb

Re: SQL Server 2005 CLR marked for unload due to memory pressure error

rremus — Mon, 22 Feb 2010 23:04:59 GMT

Atasezi debugger-ul (Windbg), incarci SOS cu :

.loadby sos mscorwks

si cauti leak-ul. Mai intit vezi ce tipuri si cite instante ai in heap:

!dumpheap -stat

Apoi vezi unde sint instantele din tipul cu cele mai multe obiecte:

!dumpheap -type <LeakedTypeName>

si, daca mai e nevoie, cauti sa vezi ce pastreaza o referinta ce cauzeaza leak-ul:

!gcroot <AddressOfObject>

Vezi http://rusanu.com/2009/01/19/clr-memory-leak/

SQL Server 2005 CLR marked for unload due to memory pressure error

MrSmersh — Mon, 22 Feb 2010 15:40:51 GMT

Am un trigger CLR pe SQL Server 2005, ca din cutie, fara SP, fara hotfixs si asa.
Si din cind in cind nu mai pot modifica nimic in tabela cu triggeru

Cam asa ceva am in log

02/22/2010 12:20:09,spid69,Unknown,AppDomain 33 (xxx.dbo[runtime].32) created.
02/22/2010 12:20:09,spid55,Unknown,AppDomain 32 (xxx.dbo[runtime].31) unloaded.
02/22/2010 12:20:02,spid1s,Unknown,AppDomain 32 (xxx.dbo[runtime].31) is marked for unload due to memory pressure.
02/22/2010 12:19:59,spid55,Unknown,AppDomain 32 (xxx.dbo[runtime].31) created.
02/22/2010 12:19:56,spid1s,Unknown,AppDomain 31 (xxx.dbo[runtime].30) unloaded.
02/22/2010 12:19:56,spid1s,Unknown,AppDomain 31 (xxx.dbo[runtime].30) is marked for unload due to memory pressure.
02/22/2010 12:07:38,spid62,Unknown,AppDomain 31 (xxx.dbo[runtime].30) created.
02/22/2010 12:07:37,spid1s,Unknown,AppDomain 30 (xxx.dbo[runtime].29) unloaded.
02/22/2010 12:07:37,spid1s,Unknown,AppDomain 30 (xxx.dbo[runtime].29) is marked for unload due to memory pressure.
02/22/2010 12:00:29,spid55,Unknown,AppDomain 30 (xx.dbo[runtime].29) created.

Trigger are un SqlConnecion, sqlCommand si un SqlDataReader, le dadeam close dar nu exclud un leak....

Idei de unde sa apuc problema? Am trecut pe using toate si dau close la tot ce prind, altceva.

Multumesc!