I am having the 'Failed to create AppDomain' issue in a production instance. This is typically attributed to memory pressure(not the case here) or pending .Net updates. The OS has been restarted and the issue persists.
Version: Microsoft SQL Server 2012 - 11.0.5058.0 (Intel X86) May 14 2014 16:44:52 Copyright (c) Microsoft Corporation Standard Edition on Windows NT 6.3 <X64> (Build 9600: ) (WOW64) (Hypervisor)
Moving beyond the simple solutions, it seems as if the only other troubleshooting step is look at the created dump file. The .Net subsystem in the OS seems otherwise healthy. I can create programs that reference System.Data and run with no issues.
What other tools exist to troubleshoot issues in the CLR feature of SQL Server?
The full error is-
DESCRIPTION: Failed to create AppDomain "master.sys[runtime].52". Could not load file or assembly 'System.Data, Version=126.96.36.199, Culture=neutral, PublicKeyToken=b77a5c561934e089' or one of its dependencies. Not enough storage is available to process this command.
(Exception from HRESULT: 0x80070008)