When SQL Server creates a CLR appdomain to run code in (a runtime appdomain as noted in the previous blog entry ), the appdomain normally stays in place for the lifetime of SQL Server. This is done to save appdomain create/teardown and assembly load time. Read More...