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; } } }

Performance issues on ArcGIS 10.4 and SQLServer Express

deleted-user-0W0-oLHxDjCX

Hi everyone

I would like to know if there are some reporting about performance issues on ArcGIS Server 10.4 Workgroup and SQL Server Express 2012 SP4. The server machine specification is showed below:

We have a polygon layer (parcel) with numbers of about 200.000 features. This layer has many relationship classes (something around 6 tables with 200,000-300,000 records each).

We did all spacial and traditional indexes and nothing solved the performance issues.

Our time response revolves arround 5-7s on each pan on the map.

Sincerely

Ezequias

Encuentra más publicaciones etiquetadas con

Accepted answers

All comments

JakeSkinner

Hi Ezequias,

The poor performance could be due to a number of factors. One thing to check is when the last time the geodatabase was compressed. If the geodatabase is edited often, you will want to compress the database on a regular basis.

deleted-user-0W0-oLHxDjCX

We did the compress recently. The editing process will not be performed briefly.

Thanks anyway.

JakeSkinner

What is the geometry type of the feature class? You can check this by right-clicking on the feature class in Catalog window > Properties > General tab. Under Geometry Properties it will state the type (i..e Geometry). If it is using Geometry I would recommend copying the feature class to SDEBINARY. I've had better performance with SDEBINARY compared to the native Geometry storage type. Below was a test I performed. I used PerfQAnalyzer to compare rendering times. The PA_Streets layer is stored with GEOMETRY storage, and PA_Streets_SDEBINARY is stored with SDEBINARY.

The feature class contains over 1.1 million records. You can see the SDEBINARY layer only took 12 seconds to render compared to 306 seconds for the layer stored with GEOMETRY.

To change the geometry of the feature class you can do a copy/paste into the geodatabase and choose the keyword SDEBINARY.

deleted-user-0W0-oLHxDjCX

Thank you so much for this suggestion. We are performing more tests now with PerfQAnalyzer. We are identifying the layers with problem. The first tests are on polygons (parcel) and Building (with 2mi of vertices).

We also updated the SQL Server 2012 to SQL Server 2014 and the performance is getting better.

I will keep you informed.

Sincerely

Ezequias Rocha

deleted-user-0W0-oLHxDjCX

Dear Jake

PerfQAnalyzer 10.4 is not considering decimal places markers on countries that switches "," and "." positioning it as decimal place separator and thousands separator (IE: Brazil).

We found this problem on the log file. We did a work around by changing regional definitions.

Best regards

Ezequias

deleted-user-0W0-oLHxDjCX

Dear Jake Skinner

Some numbers to consider:

Buildings (polygon) : 2,389,643 vertices 35.94666s

Parcel (polygon) : 402,431 vertices 19.68752s

Sincerely

Ezequias

George_Thompson

Hi Ezequias - One thing to consider when using workgroup geodatabases is related to the SQL Server Express.

Microsoft limits the use of SQL Server Express to one CPU (or core within a socket) and 1GB of RAM. The maximum database size for SQL Server 2005 or 2008 Express is limited to 4GB. The maximum database size for SQL Server 2008 Express R2 is 10GB. (Consult your Esri license agreement for specific information on the instance size limitations for your implementation.)

Types of geodatabases—ArcGIS Help | ArcGIS Desktop

Here is the Microsoft documentation on the limitations: Compute Capacity Limits by Edition of SQL Server

https://community.esri.com/groups/geodatabase?sr=search&searchId=63411611-3a1b-48fb-8b32-c2af8515830a&searchIndex=0‌

Únete a la Conversación

Los miembros registrados pueden publicar, seguir actualizaciones y más. ¿Nuevo aquí? Regístrate gratis.

Enlaces Rápidos

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