AnsweredAssumed Answered

RAM for SQL Server hosting Enterprise Geodatabases

Question asked by clinton.ballandis on May 27, 2018
Latest reply on Jun 8, 2018 by George_Thompson-esristaff


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.