We are currently having memory pressure issues with the SQL server box that hosts our enterprise geodatabases.
The specs for the SQL Server Box are as follows:
Intel Xeon CPU E5-2660 v3 @ 2.60 GHz 2.59GHz (2 processors)
Installed memory (RAM): 16 GB
Running SQL 2014 SP1 and Windows Server 2012 R2
We have about 50 spatial databases with a total size of 200GB
We are getting the following errors in ArcMap:
Error exporting data.
Table schema changes after cursor declared [4200:[Microsoft][SQL Server Native Client 11][SQL Server]
Could not complete cursor operation because the schema changed after the cursor was declared.]
AppDomain unload. You may have encountered behavior described in Esri Technical Article 43036 and Microsoft Defect 3374271 [42000:[Microsoft][SQL Server Native Client 11.0][SQL Server]The app domain with specified version id (5870) was unloaded due to memory pressure and could not be found.]
Below is a extract from the SQL Logs:
From a quick google search it appears that we may need an increase in RAM ?
Can anyone let me know the amount of RAM that they are have installed on their SQL boxes. I'm trying to justify
a RAM upgrade to at least 32gb ?
If anyone else has encountered this issue and has another fix other than increasing the RAM please let me know.