How is .NET Appdomain allocated in SQL SERVER 2005?.NET Appdomain allocation depends on the following:
- For every database a different Appdomain is allocated
- For every user a different Appdomain is allocated
How is .NET Appdomain allocated in SQL SERVER 2005? A separate Appdomian is created for each database in order to run the database code. The appdomain may be allocated based on identity of the user who owns the assembly. The memory allocated to the instantiations of .Net type objects is done from a pool of close memory managed by CLR. The .Net framework also has a garbage collector for unusable objects and reclaiming the memory.