\nPeople (especially DBAs) want to see what those pesky appdomains are doing in SQLCLR.\n<\/p>\n
\nBack in beta1 there was a system function, master.sys.fn_appdomains(), that showed which appdomains were running and which assemblies were loaded in the appdomains, number of bytes used, etc. In beta2 this view stopped working and, although you can watch appdomains being created and destroyed in the SQL Server log, I'd always missed master.sys.fn_appdomains().\n<\/p>\n
\nYou can get this information and more in the Dec CTP build:\n<\/p>\n
\n— appdomains
\nselect * from sys.dm_clr_appdomains
\n— loaded assemblies
\nselect * from sys.dm_clr_loaded_assemblies\n<\/p>\n
\n— You can even get managed code execution statistics for currently executing queries
\nselect command, exec_managed_code from sys.dm_exec_requests\n<\/p>\n
\n
\nmaster.sys.fn_appdomains is still around, but it doesn't return anything any more. Look for more CLR statistics in the dynamic management views (and elsewhere) in future betas.<\/p>\n","protected":false},"excerpt":{"rendered":"
People (especially DBAs) want to see what those pesky appdomains are doing in SQLCLR. Back in beta1 there was a system function, master.sys.fn_appdomains(), that showed which appdomains were running and which assemblies were loaded in the appdomains, number of bytes used, etc. In beta2 this view stopped working and, although you can watch appdomains being […]<\/p>\n","protected":false},"author":7,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[28,38],"tags":[],"class_list":["post-967","post","type-post","status-publish","format-standard","hentry","category-sql-server-2005","category-sqlclr"],"yoast_head":"\n