ArcMAP 10.5 Slow Performance

TerryAdams · ‎02-19-2017

Hello All,

We have just updated from ArcGIS 10.3 to ArcGIS 10.5.

Suffering from very slow performance in ArcMAP now with certain things. I've completely re-made MXD's from scratch under 10.5 that I had under 10.3 to remove possible changeover issues.

When I simply tick on/off layers it takes a long time (1 minute or more) to update the display or give me control of ArcMap back.

When I save edits - long time to do that (2 minutes or more)

When I change a layer from editable to not editable - long time (1 minute) to do that.

I'd have maybe 10 layers in the MXD with JPEG 2000 aerial photo loaded in - but not displayed.

Arc Catalog displays layers quickly - as you'd expect. Loading one or 2 layers into ArcMAP also seems ok. But more than that *really* seems to slow it down. I never had extremely slow responses like this under 10.3.

We're putting in a support call but just wondering if anyone else has noticed this - and might know what the cause is. Data sits in SQL 2012 with ARCSDE.

MarkBratcher · ‎10-19-2017

Any further solutions to the performance issue in 10.5 sde? We have tried both uninstalling all previous version folders and reinstalling as well as switching to the ODBC driver instead of native client but we are still having severe performance issues to the point you can hardly edit.

MichaelHewitt · ‎10-20-2017

I did as suggested, as well, and did a clean install of 10.5.1 (removed all things ESRI/ArcGIS). My original install was an upgrade from 10.3.1. Things have sped up a little. I have noticed that when I have an MXD with features from my SDE Geodatabase added, things seem to move slower. Still not an issue with the computers on our office network running 10.3.1. I am relatively convinced something new in 10.5.x is still causing the slowdown.

I have one of the older computers in the office, it is the litmus test for the others. Our server is a few years old as well and our storage is via RAID Towers JBOD configuration. So I expect things to move a little slower since it isn't local data. But what I saw and continue to see to a point is ridiculous. 3 minutes to load an MXD... really? Adding and removing layers is down to 30-60 seconds now. Zoom to a layer is the same. Editing in the SDE Geodatabase is fine. Stopping and saving edits takes about 30 seconds.

There have been a few Microsoft SQL server updates lately via Windows update. I think I am at SQL Server 2014 (KB3045324) which installed properly last month. I am using the ODBC driver. There was a Service Pack 2 (KB3171021) and a Security Update for SQL Server 2014 Service Pack 2 GDR (KB4019093) that failed recently.

RickGeittmann · ‎10-20-2017

Mark,

Did you upgrade to SDE databases through Arc Catalog to the later version?

I have also determined there may perhaps be an issue due to the changes in the coding of SQL 2014 and later engines.

Check you logs on Arc Server and on SQL and see if you are getting any errors of an AppDomain unloading due to memory pressure issue - I am currently working through that issue on our systems.

MichaelHewitt · ‎10-20-2017

I second that Rick and Mark, informational articles through the Arc GIS Server for Workgroup program (used to be called ArcSDE... the change names on these things so much it's annoying) it suggested I start with a new enterprise geodatabase. So I backed up my old enterprise geodatabase and brought the feature classes back in once the upgrade was complete via ArcCatalog on a client computer.

There was a whole table of ArcGIS Server versions and which ones worked with what SQL versions. Since I planned to upgrade in stages, I chose SQL 2014 because that would also work with 10.3.1. When (or If) I upgrade all of them to 10.5.1 then I could use SQL 2016 maybe. It all seems a little sketchy.

BTW, Mark, did you install the ArcGIS 10.5.x patch for SQL from ESRI that I mentioned above? I did and it might have helped a little. It had to do with authentication issues. Maybe your issue?

I found my SQL logs and there seem to be no errors with AppDomain. It seems to be starting the database with the correct name at different times when it is being accessed by different computers (spid#) on the network. I guess I cannot access ArcGIS Server logs without the Manager program?

I don't actually have SQL Managment Studio or ArcGIS Server Manager installed. I opted for a simplified install on both. For what I do, I don't need them.

RickGeittmann · ‎10-20-2017

Michael,

Arc Server manager is installed by default below is how you would access it from the local machine [localhost] or remotely via http if you have it enable for management over the network

http:// [server IP or name or localhost]:6080/arcgis/manager/

You would need to know the management account created to login with

http://server.arcgis.com/en/server/latest/install/windows/log-in-to-manager.htm

From there you would be able to look at the logs for arc server for MS SQL you would need SSMS installed and either do remote administration or install on the server its self and remote in and then bring up SSMS locally on that machine.

MichaelHewitt · ‎10-20-2017

Rick,

Not necessarily. I used to have ArcGIS Server Manager, but there is a different program I installed this time instead... A concurrent license might be different? They had me install "database_server_workgroup_1051_156258.exe".

I cant get to the 6080 port on my server anymore.

I don't know what SSMS is (not great with alphabet soup)... I was told that ArcGIS Server Manager was something you needed if you were hosting data over the internet. Since I am hosting data to an office network, I didn't need it?

KevinRubalcaba · ‎11-08-2017

Terry,

It never hurts to do a complete uninstall of older version of desktop and their related folders and then install the newer version of desktop.

We had performance issues after upgrading to 10.5.1 and we called tech support. After rebuilding indexes (Rebuild Indexes (Data management) tool) and analyzing datasets (Analyze Datasets (Data Management) tool) our performance problems were solved. We were not routinely rebuilding indexes and over time it bogged everything down and after our upgrade to 10.5.1 and turning on editor tracking, it finally had enough and slowed to a crawl.

So, remember to routinely rebuild your indexes and call tech support if you need assistance, they are an invaluable resource.

Kevin Rubalcaba

GIS Analyst

MichaelHewitt · ‎11-08-2017

Kevin,

Thank you for the response. I am glad that tech support will talk to you. I have a concurrent license and unfortunately, I am not the purchaser of the software. Tech support's first question is, "What is your customer number?" We have tried in the past to have my account linked so I am "allowed" to talk to them and somehow the connection is always missing. I gave up calling them because of the hassle every time I attempted to call. But it's their policy... Also, there is something to be said for a company that makes software that every other upgrade has problems after installing, but I digress.

I had reluctantly uninstalled and "fresh installed" 10.5.1. Initially, I upgraded from 10.3.1. No change in speed.

So the Analyze Datasets and Rebuild Indexes tool are found in ArcToolbox>Data Management>Geodatabase Administration> for anyone following along. Funny thing is that I had done all of that in a different way when I was forced to upgrade my Enterprise (formerly ArcSDE) Geodatabase server-side Database Server Workgroup (also formerly ArcSDE) program and SQL. I have the recommended flavor of SQL 2014 as per ESRI help files on the subject.

It was so much easier when they kept the names the same, who decided to rename them anyway?

I tried these tools anyway, and the results were the same. Nada... Still, almost 4 mins to open the MXD (no red exclamation points). Editing the ArcSDE Geodatabase seemed to be a few (up to 10) seconds for each task. Like I said before editing the geodatabase was never really a problem. It's the regular tasks. For instance, Zoom-in takes 40 seconds. Didn't have time to test more. It's not a death crawl, but it's just enough to be really annoying.

I am really contemplating going back to 10.3.1. I kept my other computers there until I am satisfied that it's not going to slow down the productivity of the entire office.

RickGeittmann · ‎11-14-2017

Hey gang,

OK so still had real slow performance from the databases so as someone else mentioned earlier in the thread I went through this past Friday (11/10/2017) evening and ran the Rebuild Indexes tool against the main database that was giving us fits and customers reported this morning this were running fast and no problems.

Toolboxes\System Toolboxes\Data Management Tools.tbx\Geodatabase Administration\Rebuild Indexes

Took a few minutes to run but folks are very happy with the result - try it - might help.

MichaelHewitt · ‎11-14-2017

Rick,

I am glad it worked for you.

I tried Rebuild Indexes (and Analyze Datasets) tools and unfortunately, it did not work for me. Maybe I was writing a little too much on my last post and no one caught that...

I was rambling on about the different things I have tried to no avail. Just a little frustrated, I guess.

I am happy that someone is getting some good results using this thread.