nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Anyone getting the error "The app domain ... was unloaded due to memory pressure and could not be found"

AaronCohen

Several months ago we upgraded SQL Server to 2014 on Win2012. Geodb is at 10.2.2 still.

Since the upgrade, we see performance degrade over about a 2 week period to the point of having to restart the DB server.

The SQL logs show an increasing number of error statements as shown in the title. Example: on day 10 after a restart I get one unloaded error and it repeats over 5 days, then I get 3 errors on day 16, then 40 on day 17 and finally 3500 on roughly the 18-21st day. At this point the server is paralyzed across the whole instance and needs to be restarted.

This ESRI tech article refers to a Microsoft memory error but gives no details.

Error: The app domain with specified version id (%d) was unloaded due to memory pressure and could not be found

Before we drop $$ on Microsoft, does anyone have a similar experience?

Best I can tell it seems to deal with spatial data types, CLR and memory.

ESRI confirmed that CLR is not required for ArcGIS to work with SQL Server.

Any help is appreciated

TIA

Find more posts tagged with

Accepted answers

George Thompson

Hi Aaron,

Yes, based on your description I would say you are correct. As long as the SQL server version (build) matches what is listed (as the minium or "base build") you should be good. I do know that changes to that page are made when warranted for a specific RDBMS.

I always ran the following SQL Server query:

@version

This would give me the full build information and then compared it to this site for the "English" translation (i.e 11.0.3000.0 = SQL Server 2012 SP1)

Microsoft SQL Server Version List or the MS page: https://support.microsoft.com/en-us/kb/321185

Hope this helps and I am glad to help clear up any confusion on this subject as I know it can be confusing.

All comments

baohuachu3

Hi all,

In my replica I try to let the data in one replica smaller, that means select fewer layers in one replica and then the problem may not appear.

AaronCohen

Hey George

So as of today (10/11/2016) the supported RDBMS page says this:

So are these the "base builds" referred to in the policy?

I would surmise then that loading SQL 2012 SP1 is the "supported" "base build" of the software and that

loading pre SP1 would be problematic which is exactly what seemed to be the issue we were experiencing.

When my problem began the requirements page did not include SP1, leading myself to believe I should not be loading up SP1 or SP2. (even though that was the solution to the problem)

In other words, we should look at the Reqs. page as the lowest level and anything above it is OK to install?

So if MS put out SP3 tomorrow it would be good to load from ESRI's perspective?

I always used this page as the ceiling and its seems now it is the floor for installed version determination.

Am I understanding correctly?

BTW - thanks for engaging on the topic.

TomDowd

Thank you!

George Thompson

Hi acmadison and tdowd,

As for the supported version of SQL Server 2014, support starts at the base version of 2014. Just cause no service packs are listed does not mean that they are not supported.

Non-certification of an environment does not necessarily mean it is not supported. That environment is supported if it meets or exceeds the base build environment and that environment is known to not fail. Environments that are known to not work are usually documented on the product support page as soon as that information is available.

Supported Environment Policy

So patching to the latest update is supported unless otherwise noted.

Hope this helps clear up the supported policy.

AaronCohen

ESRI does not list SP1 or SP2 yet as supported so go with the base install to stay compliant.

Here is there list

Standard/Enterprise editions

Microsoft SQL Server 2014 (64-bit)

http://desktop.arcgis.com/en/arcmap/10.3/get-started/system-requirements/database-requirements-sqlserver.htm

AaronCohen

Sorry for not posting a solution.

Long story short - ESRIs KB says to call Microsoft. That costs money. We didn't do that.

The undocumented solution was to install the highest SQL 2014 service pack available.

It turned into a comedy of errors but the end result was a solution.

This MS page shows all the current SP's for the different versions SQL 2014.

https://support.microsoft.com/en-us/kb/2936603

We are on SQL Server 2014 SP1 CU7 Build version 12.0.4459.0

I have had only 3 UNLOADDED ... errors since the we patched to CU7 and "normal" performance has returned

Whether you are at the base install or SP1 or SP2 you want to install the highest/latest CU.

Hope this helps.

P.S. - always make a backup!!!

TomDowd

Hi Aaron,

We are experiencing a similar issue in SQL Server 2014. I was wondering if you found a solution. Thanks

AaronCohen

Here they are. Thoughts?

George Thompson

I have seen the error before, usually has to do with something on the SQL Server side and not the ArcGIS side. This would fall under tuning of the RDBMS.

How much memory is the SQL Server service using? You mention that you have set the MAX limit for SQL Server to 8GB and the service is using 60% of the overall memory. That service may be out of memory and needs to be increased in the SQL Server settings.

Can you provide similar screenshots?

AaronCohen

Hi George

The machine has 16GB of RAM - 8 of that for the DB.

Total memory used sits about 60% with the SQL service being the only thing consuming CPU at roughly8-10%

The machine is virtual and only has SQL on it.

Have you had this error yourself?

George Thompson

Hi Aaron,

What is the memory limits that you have set within SQL Server?

What is the memory utilization of the machine that SQL Server is installed on?

Is ArcGIS for Server also on the same machine as SQL Server?

How much memory on the Win2012 machine? Is it a VM or physical machine?

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.