SQLCLR troubleshooting

check-sqlclr-domains.sql

select left(appdomain_name, 19) as appdomain_name, [state]
, sum(total_allocated_memory_kb) / 1024. AS total_allocated_memory_MB
, sum(survived_memory_kb) / 1024. as survived_memory_MB
from sys.dm_clr_appdomains
group by left(appdomain_name, 19), [state]

--select * from sys.dm_clr_properties

--select * from sys.dm_clr_appdomains
--select * from sys.dm_clr_loaded_assemblies

--select * from sys.dm_clr_tasks