Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 .NET Inside SQL Server (2005)
 SQLCLR instance destroyed randomly

Author  Topic 

aboukhris
Starting Member

1 Post

Posted - 2009-01-21 : 07:35:41
Hello,

Hello every body,

I have a very big problem,

I have created an SQLCLR Assembly . in witch I have connections to a direct SQLConnection managed by a single singleton instance.
I use the assembly by calling it from a stored procedure.

everything works fine but My probleme is that the singleton instance of the CLR is destroyed randomly. when i checked in the envent manager i found this 2 events :
1-APPDomain 7 (My_SBObase.dboruntime.7) is marked for unload due to memory pressure.
2-APPDomain 7 (My_SBObase.dboruntime.7) unloaded.

PS: i have also a windows application that checks if the instance is still in memory or not. for this it execute a stored procedure that return the connection status every 5 secondes.

thanks for your help !

ABO.
   

- Advertisement -