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

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