AnsweredAssumed Answered

RAM for SQL Server hosting Enterprise Geodatabases

Question asked by clinton.ballandis on May 27, 2018
Latest reply on May 22, 2019 by rickag

Hi,

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.

 

Thanks,

 

Clinton 

Outcomes