GIS layer slow performance in arcgis server 10.3, using oracle sde

1700
5
06-22-2017 04:55 AM
ElieRizk
Occasional Contributor

i have a feature layer stored in an oracle sde, this layer is the dissolve output of ~1M parcels (with lot of vertices), the problem is that when i am using this layer in arcmap with symbology the layer perfermance is good, but when this layer is displayed in web application using arcgis map service it displays very slow and take around 10 seconds.

why the display performance differs between arcmap and arcgis server for the same layer in the same data source??

Tags (1)
0 Kudos
5 Replies
JakeSkinner
Esri Esteemed Contributor

Hi Elie,

This could possibly be a network issue.  I would test this by exporting the feature class to a File Geodatabase.  Copy the File Geodatabase to a folder on the Oracle server, publish a service, and see how performance is.  Then, copy the File Geodatabase to a folder on the ArcGIS Server server, and publish a service from there to compare how the performance is.

JonathanQuinn
Esri Notable Contributor

If ArcMap is on the same machine as the Oracle database, then Jake Skinner‌'s suggestion is a good test to go through.

You can also take a look at the Verbose logs, which will give you a more granular look at the export map process:

http://server.arcgis.com/en/server/latest/administer/windows/map-service-log-codes.htm

Take a look at the information under Example: ExportMapImage.  After you enable the Time Elapsed column within the logs, you'll be able to see exactly how long each operation took.  If the Data Access step takes a long time, then you know it's some sort of latency issue between your ArcGIS Server machine and the Oracle database.

ElieRizk
Occasional Contributor

hi Jonathan,

please can you help me to analyse the below log sheet extracted from the ArcGis server, what can you deduce as a conclusion from your perspective.

sorry for the long list below, but i dont know how to attach a file.

thank you,

LevelTimeMessageCodeTime ElapsedMethod name
VERBOSEJun 23, 2017, 11:25:34 AMNumber of features drawn: 51030190Map.Draw
VERBOSEJun 23, 2017, 11:25:34 AMSymbol Drawing1030230.00011Map.Draw
VERBOSEJun 23, 2017, 11:25:34 AMData Access1030240.60359Map.Draw
VERBOSEJun 23, 2017, 11:25:34 AMSymbolizing1030240.00018Map.Draw
VERBOSEJun 23, 2017, 11:25:34 AMExecute Query1030240.04625Map.Draw
VERBOSEJun 23, 2017, 11:25:34 AMBeginning of layer draw: حنيفة وروافده103000 Map.Draw
VERBOSEJun 23, 2017, 11:25:34 AMEnd of layer draw: الأحياء1030010.00063Map.Draw
VERBOSEJun 23, 2017, 11:25:34 AMNumber of features drawn: 01030190Map.Draw
VERBOSEJun 23, 2017, 11:25:34 AMSymbol Drawing1030230Map.Draw
VERBOSEJun 23, 2017, 11:25:34 AMData Access1030240Map.Draw
VERBOSEJun 23, 2017, 11:25:34 AMSymbolizing1030240Map.Draw
VERBOSEJun 23, 2017, 11:25:34 AMExecute Query1030240Map.Draw
VERBOSEJun 23, 2017, 11:25:34 AMBeginning of layer draw: الأحياء103000 Map.Draw
VERBOSEJun 23, 2017, 11:25:34 AMEnd of preparation.100950.00071MapServer.ExportMapImage
VERBOSEJun 23, 2017, 11:25:34 AMBegining of preparation.10094 MapServer.ExportMapImage
FINEJun 23, 2017, 11:25:34 AM

Extent:571235.878435,2696405.435963,

761962.033774,2780466.506441; Size:1366,592; Scale:577790.55

10138 
FINEJun 23, 2017, 11:25:34 AMBegin ExportMapImage10010 MapServer.ExportMapImage
FINEJun 23, 2017, 11:25:34 AMREST request received. Request size is 178 characters.100001 /export
VERBOSEJun 23, 2017, 11:25:35 AMNumber of features drawn: 51030190Map.Draw
VERBOSEJun 23, 2017, 11:25:35 AMSymbol Drawing1030230.00003Map.Draw
VERBOSEJun 23, 2017, 11:25:35 AMData Access1030240.60899Map.Draw
VERBOSEJun 23, 2017, 11:25:35 AMSymbolizing1030240.00016Map.Draw
VERBOSEJun 23, 2017, 11:25:35 AMExecute Query1030240.04211Map.Draw
VERBOSEJun 23, 2017, 11:25:36 AMNumber of features drawn: 51030190Map.Draw
VERBOSEJun 23, 2017, 11:25:36 AMSymbol Drawing1030230.00395Map.Draw
VERBOSEJun 23, 2017, 11:25:36 AMData Access1030240.59875Map.Draw
VERBOSEJun 23, 2017, 11:25:36 AMSymbolizing1030240.00016Map.Draw
VERBOSEJun 23, 2017, 11:25:36 AMExecute Query1030240.03376Map.Draw
VERBOSEJun 23, 2017, 11:25:36 AMNumber of features drawn: 51030190Map.Draw
VERBOSEJun 23, 2017, 11:25:36 AMSymbol Drawing1030230.00138Map.Draw
VERBOSEJun 23, 2017, 11:25:36 AMData Access1030240.72624Map.Draw
VERBOSEJun 23, 2017, 11:25:36 AMSymbolizing1030240.00064Map.Draw
VERBOSEJun 23, 2017, 11:25:36 AMExecute Query1030240.04144Map.Draw
VERBOSEJun 23, 2017, 11:25:37 AMNumber of features drawn: 51030190Map.Draw
VERBOSEJun 23, 2017, 11:25:37 AMSymbol Drawing1030230.0248Map.Draw
VERBOSEJun 23, 2017, 11:25:37 AMData Access1030240.58133Map.Draw
VERBOSEJun 23, 2017, 11:25:37 AMSymbolizing1030240.00025Map.Draw
VERBOSEJun 23, 2017, 11:25:37 AMExecute Query1030240.14112Map.Draw
VERBOSEJun 23, 2017, 11:25:38 AMNumber of features drawn: 51030190Map.Draw
VERBOSEJun 23, 2017, 11:25:38 AMSymbol Drawing1030230.00243Map.Draw
VERBOSEJun 23, 2017, 11:25:38 AMData Access1030240.62225Map.Draw
VERBOSEJun 23, 2017, 11:25:38 AMSymbolizing1030240.00017Map.Draw
VERBOSEJun 23, 2017, 11:25:38 AMExecute Query1030240.03416Map.Draw
VERBOSEJun 23, 2017, 11:25:38 AMNumber of features drawn: 51030190Map.Draw
VERBOSEJun 23, 2017, 11:25:38 AMSymbol Drawing1030230.00003Map.Draw
VERBOSEJun 23, 2017, 11:25:38 AMData Access1030240.62662Map.Draw
VERBOSEJun 23, 2017, 11:25:38 AMSymbolizing1030240.00017Map.Draw
VERBOSEJun 23, 2017, 11:25:38 AMExecute Query1030240.03625Map.Draw
VERBOSEJun 23, 2017, 11:25:39 AMNumber of features drawn: 51030190Map.Draw
VERBOSEJun 23, 2017, 11:25:39 AMSymbol Drawing1030230.00314Map.Draw
VERBOSEJun 23, 2017, 11:25:39 AMData Access1030240.59717Map.Draw
VERBOSEJun 23, 2017, 11:25:39 AMSymbolizing1030240.00016Map.Draw
VERBOSEJun 23, 2017, 11:25:39 AMExecute Query1030240.03336Map.Draw
VERBOSEJun 23, 2017, 11:25:40 AMBeginning of layer draw: المناطق المغطاة بالأنظمة المعتمدة103000 Map.Draw
VERBOSEJun 23, 2017, 11:25:40 AMEnd of layer draw: وادي السلي1030010.23067Map.Draw
VERBOSEJun 23, 2017, 11:25:40 AMNumber of features drawn: 21030190Map.Draw
VERBOSEJun 23, 2017, 11:25:40 AMSymbol Drawing1030230.00572Map.Draw
VERBOSEJun 23, 2017, 11:25:40 AMData Access1030240.18493Map.Draw
VERBOSEJun 23, 2017, 11:25:40 AMSymbolizing1030240.00007Map.Draw
VERBOSEJun 23, 2017, 11:25:40 AMExecute Query1030240.03781Map.Draw
VERBOSEJun 23, 2017, 11:25:40 AMBeginning of layer draw: وادي السلي103000 Map.Draw
VERBOSEJun 23, 2017, 11:25:40 AMEnd of layer draw: حنيفة وروافده1030016.09187Map.Draw
VERBOSEJun 23, 2017, 11:25:40 AMNumber of features drawn: 51030190Map.Draw
VERBOSEJun 23, 2017, 11:25:40 AMSymbol Drawing1030230.00146Map.Draw
VERBOSEJun 23, 2017, 11:25:40 AMData Access1030240.59812Map.Draw
VERBOSEJun 23, 2017, 11:25:40 AMSymbolizing1030240.00016Map.Draw
VERBOSEJun 23, 2017, 11:25:40 AMExecute Query1030240.04012Map.Draw
VERBOSEJun 23, 2017, 11:25:56 AMEnd of layer draw: حرم خط الغاز1030010.01711Map.Draw
VERBOSEJun 23, 2017, 11:25:56 AMNumber of features drawn: 11030190Map.Draw
VERBOSEJun 23, 2017, 11:25:56 AMSymbol Drawing1030230.00211Map.Draw
VERBOSEJun 23, 2017, 11:25:56 AMData Access1030240.00277Map.Draw
VERBOSEJun 23, 2017, 11:25:56 AMSymbolizing1030240.00009Map.Draw
VERBOSEJun 23, 2017, 11:25:56 AMExecute Query1030240.01081Map.Draw
VERBOSEJun 23, 2017, 11:25:56 AMBeginning of layer draw: حرم خط الغاز103000 Map.Draw
VERBOSEJun 23, 2017, 11:25:56 AMEnd of layer draw: المناطق المغطاة بالأنظمة المعتمدة10300116.49729Map.Draw
VERBOSEJun 23, 2017, 11:25:56 AMNumber of features drawn: 15461030190Map.Draw
VERBOSEJun 23, 2017, 11:25:56 AMSymbol Drawing1030230.27281Map.Draw
VERBOSEJun 23, 2017, 11:25:56 AMData Access10302416.02848Map.Draw
VERBOSEJun 23, 2017, 11:25:56 AMSymbolizing1030240.0375Map.Draw
VERBOSEJun 23, 2017, 11:25:56 AMExecute Query1030240.10768Map.Draw
FINEJun 23, 2017, 11:25:57 AM

REST request successfully processed.

Response size is 197605 characters.

10000422.98171/export
FINEJun 23, 2017, 11:25:57 AMEnd ExportMapImage1001122.98007MapServer.ExportMapImage
VERBOSEJun 23, 2017, 11:26:08 AMBeginning of layer draw: حنيفة وروافده103000 Map.Draw
VERBOSEJun 23, 2017, 11:26:08 AMEnd of layer draw: الأحياء1030010.00095Map.Draw
VERBOSEJun 23, 2017, 11:26:08 AMNumber of features drawn: 01030190Map.Draw
VERBOSEJun 23, 2017, 11:26:08 AMSymbol Drawing1030230Map.Draw
VERBOSEJun 23, 2017, 11:26:08 AMData Access1030240Map.Draw
VERBOSEJun 23, 2017, 11:26:08 AMSymbolizing1030240Map.Draw
VERBOSEJun 23, 2017, 11:26:08 AMExecute Query1030240Map.Draw
VERBOSEJun 23, 2017, 11:26:08 AMBeginning of layer draw: الأحياء103000 Map.Draw
VERBOSEJun 23, 2017, 11:26:08 AMEnd of preparation.100950.00081MapServer.ExportMapImage
VERBOSEJun 23, 2017, 11:26:08 AMBegining of preparation.10094 MapServer.ExportMapImage
FINEJun 23, 2017, 11:26:08 AM

Extent:655297.980760,2732504.177465,

679139.822770,2743012.811597; Size:1366,592; Scale:72223.82

10138 
FINEJun 23, 2017, 11:26:08 AMBegin ExportMapImage10010 MapServer.ExportMapImage
FINEJun 23, 2017, 11:26:08 AMREST request received. Request size is 179 characters.100001 /export
VERBOSEJun 23, 2017, 11:26:09 AMNumber of features drawn: 41030190Map.Draw
VERBOSEJun 23, 2017, 11:26:09 AMSymbol Drawing1030230.00003Map.Draw
VERBOSEJun 23, 2017, 11:26:09 AMData Access1030240.62609Map.Draw
VERBOSEJun 23, 2017, 11:26:09 AMSymbolizing1030240.00012Map.Draw
VERBOSEJun 23, 2017, 11:26:09 AMExecute Query1030240.14973Map.Draw
VERBOSEJun 23, 2017, 11:26:10 AMNumber of features drawn: 41030190Map.Draw
VERBOSEJun 23, 2017, 11:26:10 AMSymbol Drawing1030230.00002Map.Draw
VERBOSEJun 23, 2017, 11:26:10 AMData Access1030240.63097Map.Draw
VERBOSEJun 23, 2017, 11:26:10 AMSymbolizing1030240.0001Map.Draw
VERBOSEJun 23, 2017, 11:26:10 AMExecute Query1030240.08496Map.Draw
VERBOSEJun 23, 2017, 11:26:11 AMNumber of features drawn: 41030190Map.Draw
VERBOSEJun 23, 2017, 11:26:11 AMSymbol Drawing1030230.00004Map.Draw
VERBOSEJun 23, 2017, 11:26:11 AMData Access1030240.5949Map.Draw
VERBOSEJun 23, 2017, 11:26:11 AMSymbolizing1030240.00015Map.Draw
VERBOSEJun 23, 2017, 11:26:11 AMExecute Query1030240.14694Map.Draw
VERBOSEJun 23, 2017, 11:26:11 AMNumber of features drawn: 41030190Map.Draw
VERBOSEJun 23, 2017, 11:26:11 AMSymbol Drawing1030230.005Map.Draw
VERBOSEJun 23, 2017, 11:26:11 AMData Access1030240.71727Map.Draw
VERBOSEJun 23, 2017, 11:26:11 AMSymbolizing1030240.00058Map.Draw
VERBOSEJun 23, 2017, 11:26:11 AMExecute Query1030240.16438Map.Draw
VERBOSEJun 23, 2017, 11:26:12 AMNumber of features drawn: 41030190Map.Draw
VERBOSEJun 23, 2017, 11:26:12 AMSymbol Drawing1030230.0068Map.Draw
VERBOSEJun 23, 2017, 11:26:12 AMData Access1030240.57387Map.Draw
VERBOSEJun 23, 2017, 11:26:12 AMSymbolizing1030240.00013Map.Draw
VERBOSEJun 23, 2017, 11:26:12 AMExecute Query1030240.04249Map.Draw
VERBOSEJun 23, 2017, 11:26:13 AMNumber of features drawn: 41030190Map.Draw
VERBOSEJun 23, 2017, 11:26:13 AMSymbol Drawing1030230.00277Map.Draw
VERBOSEJun 23, 2017, 11:26:13 AMData Access1030240.58482Map.Draw
VERBOSEJun 23, 2017, 11:26:13 AMSymbolizing1030240.00015Map.Draw
VERBOSEJun 23, 2017, 11:26:13 AMExecute Query1030240.03063Map.Draw
VERBOSEJun 23, 2017, 11:26:13 AMNumber of features drawn: 41030190Map.Draw
VERBOSEJun 23, 2017, 11:26:13 AMSymbol Drawing1030230.00003Map.Draw
VERBOSEJun 23, 2017, 11:26:13 AMData Access1030240.58812Map.Draw
VERBOSEJun 23, 2017, 11:26:13 AMSymbolizing1030240.00018Map.Draw
VERBOSEJun 23, 2017, 11:26:13 AMExecute Query1030240.03667Map.Draw
VERBOSEJun 23, 2017, 11:26:14 AMNumber of features drawn: 41030190Map.Draw
VERBOSEJun 23, 2017, 11:26:14 AMSymbol Drawing1030230.00433Map.Draw
VERBOSEJun 23, 2017, 11:26:14 AMData Access1030240.59016Map.Draw
VERBOSEJun 23, 2017, 11:26:14 AMSymbolizing1030240.00015Map.Draw
VERBOSEJun 23, 2017, 11:26:14 AMExecute Query1030240.02971Map.Draw
VERBOSEJun 23, 2017, 11:26:15 AMEnd of layer draw: وادي1030010.17967Map.Draw
VERBOSEJun 23, 2017, 11:26:15 AMNumber of features drawn: 11030190Map.Draw
VERBOSEJun 23, 2017, 11:26:15 AMSymbol Drawing1030230.00276Map.Draw
VERBOSEJun 23, 2017, 11:26:15 AMData Access1030240.15937Map.Draw
VERBOSEJun 23, 2017, 11:26:15 AMSymbolizing1030240.00004Map.Draw
VERBOSEJun 23, 2017, 11:26:15 AMExecute Query1030240.01537Map.Draw
FINEJun 23, 2017, 11:26:19 AM

REST request successfully processed.

Response size is 252896 characters.

10000410.32033/export
FINEJun 23, 2017, 11:26:19 AMEnd ExportMapImage1001110.31943MapServer.ExportMapImage
FINEJun 23, 2017, 11:26:27 AMBegin ExportMapImage10010 MapServer.ExportMapImage
FINEJun 23, 2017, 11:26:27 AMREST request received. Request size is 179 characters.100001 /export
FINEJun 23, 2017, 11:26:27 AM

Extent:664037.369389,2736947.981827,

669997.575335,2739574.970418; Size:1366,592; Scale:18055.95

10138 
FINEJun 23, 2017, 11:26:34 AM

REST request successfully processed.

Response size is 142644 characters.

1000047.23262/export
FINEJun 23, 2017, 11:26:34 AMEnd ExportMapImage100117.23177MapServer.ExportMapImage
FINEJun 23, 2017, 11:26:39 AMREST request received. Request size is 178 characters.100001 /export
FINEJun 23, 2017, 11:26:39 AM

Extent:666072.976361,2737343.384273,

669053.190971,2738657.018988; Size:1366,592; Scale:9027.98

10138 
FINEJun 23, 2017, 11:26:39 AMBegin ExportMapImage10010 MapServer.ExportMapImage
FINEJun 23, 2017, 11:26:46 AMEnd ExportMapImage100116.85495MapServer.ExportMapImage
FINEJun 23, 2017, 11:26:46 AM

REST request successfully processed.

Response size is 127129 characters.

1000046.856/export
RandallWilliams
Esri Regular Contributor

The bulk of the time looks to be with ArcGIS Server attempting to access the data on your database (the data access phase), which is frequently due to some network issue. This happens prior to the query operations.

ElieRizk
Occasional Contributor

i tried Jonathan method and the results are very good in ArcMap and very bad in web application (the ArcGIS for server took around 35 s to display a 174 kb image).

i turned off all the layer in the MXD and turn it on one by one and republish (the map works very fast except for this big layer)

noting that after generalization the layer contains around 2.5 Millions vertices. (this layer added with complex symbology)

i am sharing with you all these information because it seems that ArcGIS for server has a specific problem with this layer.

0 Kudos