Common Language Runtime Related Dynamic Management Views (Transact-SQL)

from http://www.sqlserverspecialists.com/2013/03/common-language-runtime-related-dynamic.html

 

Useful for understanding and troubleshooting CLR objects executing within SQL Server. CLR objects are cached for better performance after they are used and are not destroyed immediately. CLR objects are unloaded only when SQL Server comes under memory pressure.

 

sys.dm_clr_appdomains

 

Returns a row for each AppDomain, the unit of isolation for an application running in .NET, running on the server.

SQL Server creates one AppDomain per database per owner so that all CLR objects are always executed in the same AppDomain.

 

sys.dm_clr_loaded_assemblies

 

Returns a row for each managed user assembly, i.e. managed code DLL files, loaded into the server address space.

 

sys.dm_clr_properties

 

Returns a row for each property of a CLR assembly available to the system, such as the CLR version, current state of the hosted CLR, or the CLR install directory.

 

sys.dm_clr_tasks

 

Returns a row for all currently running CLR tasks.

 

 

PERMISSIONS:

Requires VIEW SERVER STATE permission on the server.