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

ElieRizk — Thu, 22 Jun 2017 11:55:55 GMT

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??

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

JakeSkinner — Thu, 22 Jun 2017 12:17:09 GMT

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.

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

JonathanQuinn — Thu, 22 Jun 2017 15:26:19 GMT

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.

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

ElieRizk — Fri, 23 Jun 2017 08:53:55 GMT

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,

Level	Time	Message	Code	Time Elapsed	Method name
VERBOSE	Jun 23, 2017, 11:25:34 AM	Number of features drawn: 5	103019	0	Map.Draw
VERBOSE	Jun 23, 2017, 11:25:34 AM	Symbol Drawing	103023	0.00011	Map.Draw
VERBOSE	Jun 23, 2017, 11:25:34 AM	Data Access	103024	0.60359	Map.Draw
VERBOSE	Jun 23, 2017, 11:25:34 AM	Symbolizing	103024	0.00018	Map.Draw
VERBOSE	Jun 23, 2017, 11:25:34 AM	Execute Query	103024	0.04625	Map.Draw
VERBOSE	Jun 23, 2017, 11:25:34 AM	Beginning of layer draw: حنيفة وروافده	103000		Map.Draw
VERBOSE	Jun 23, 2017, 11:25:34 AM	End of layer draw: الأحياء	103001	0.00063	Map.Draw
VERBOSE	Jun 23, 2017, 11:25:34 AM	Number of features drawn: 0	103019	0	Map.Draw
VERBOSE	Jun 23, 2017, 11:25:34 AM	Symbol Drawing	103023	0	Map.Draw
VERBOSE	Jun 23, 2017, 11:25:34 AM	Data Access	103024	0	Map.Draw
VERBOSE	Jun 23, 2017, 11:25:34 AM	Symbolizing	103024	0	Map.Draw
VERBOSE	Jun 23, 2017, 11:25:34 AM	Execute Query	103024	0	Map.Draw
VERBOSE	Jun 23, 2017, 11:25:34 AM	Beginning of layer draw: الأحياء	103000		Map.Draw
VERBOSE	Jun 23, 2017, 11:25:34 AM	End of preparation.	10095	0.00071	MapServer.ExportMapImage
VERBOSE	Jun 23, 2017, 11:25:34 AM	Begining of preparation.	10094		MapServer.ExportMapImage
FINE	Jun 23, 2017, 11:25:34 AM	Extent:571235.878435,2696405.435963, 761962.033774,2780466.506441; Size:1366,592; Scale:577790.55	10138
FINE	Jun 23, 2017, 11:25:34 AM	Begin ExportMapImage	10010		MapServer.ExportMapImage
FINE	Jun 23, 2017, 11:25:34 AM	REST request received. Request size is 178 characters.	100001		/export
VERBOSE	Jun 23, 2017, 11:25:35 AM	Number of features drawn: 5	103019	0	Map.Draw
VERBOSE	Jun 23, 2017, 11:25:35 AM	Symbol Drawing	103023	0.00003	Map.Draw
VERBOSE	Jun 23, 2017, 11:25:35 AM	Data Access	103024	0.60899	Map.Draw
VERBOSE	Jun 23, 2017, 11:25:35 AM	Symbolizing	103024	0.00016	Map.Draw
VERBOSE	Jun 23, 2017, 11:25:35 AM	Execute Query	103024	0.04211	Map.Draw
VERBOSE	Jun 23, 2017, 11:25:36 AM	Number of features drawn: 5	103019	0	Map.Draw
VERBOSE	Jun 23, 2017, 11:25:36 AM	Symbol Drawing	103023	0.00395	Map.Draw
VERBOSE	Jun 23, 2017, 11:25:36 AM	Data Access	103024	0.59875	Map.Draw
VERBOSE	Jun 23, 2017, 11:25:36 AM	Symbolizing	103024	0.00016	Map.Draw
VERBOSE	Jun 23, 2017, 11:25:36 AM	Execute Query	103024	0.03376	Map.Draw
VERBOSE	Jun 23, 2017, 11:25:36 AM	Number of features drawn: 5	103019	0	Map.Draw
VERBOSE	Jun 23, 2017, 11:25:36 AM	Symbol Drawing	103023	0.00138	Map.Draw
VERBOSE	Jun 23, 2017, 11:25:36 AM	Data Access	103024	0.72624	Map.Draw
VERBOSE	Jun 23, 2017, 11:25:36 AM	Symbolizing	103024	0.00064	Map.Draw
VERBOSE	Jun 23, 2017, 11:25:36 AM	Execute Query	103024	0.04144	Map.Draw
VERBOSE	Jun 23, 2017, 11:25:37 AM	Number of features drawn: 5	103019	0	Map.Draw
VERBOSE	Jun 23, 2017, 11:25:37 AM	Symbol Drawing	103023	0.0248	Map.Draw
VERBOSE	Jun 23, 2017, 11:25:37 AM	Data Access	103024	0.58133	Map.Draw
VERBOSE	Jun 23, 2017, 11:25:37 AM	Symbolizing	103024	0.00025	Map.Draw
VERBOSE	Jun 23, 2017, 11:25:37 AM	Execute Query	103024	0.14112	Map.Draw
VERBOSE	Jun 23, 2017, 11:25:38 AM	Number of features drawn: 5	103019	0	Map.Draw
VERBOSE	Jun 23, 2017, 11:25:38 AM	Symbol Drawing	103023	0.00243	Map.Draw
VERBOSE	Jun 23, 2017, 11:25:38 AM	Data Access	103024	0.62225	Map.Draw
VERBOSE	Jun 23, 2017, 11:25:38 AM	Symbolizing	103024	0.00017	Map.Draw
VERBOSE	Jun 23, 2017, 11:25:38 AM	Execute Query	103024	0.03416	Map.Draw
VERBOSE	Jun 23, 2017, 11:25:38 AM	Number of features drawn: 5	103019	0	Map.Draw
VERBOSE	Jun 23, 2017, 11:25:38 AM	Symbol Drawing	103023	0.00003	Map.Draw
VERBOSE	Jun 23, 2017, 11:25:38 AM	Data Access	103024	0.62662	Map.Draw
VERBOSE	Jun 23, 2017, 11:25:38 AM	Symbolizing	103024	0.00017	Map.Draw
VERBOSE	Jun 23, 2017, 11:25:38 AM	Execute Query	103024	0.03625	Map.Draw
VERBOSE	Jun 23, 2017, 11:25:39 AM	Number of features drawn: 5	103019	0	Map.Draw
VERBOSE	Jun 23, 2017, 11:25:39 AM	Symbol Drawing	103023	0.00314	Map.Draw
VERBOSE	Jun 23, 2017, 11:25:39 AM	Data Access	103024	0.59717	Map.Draw
VERBOSE	Jun 23, 2017, 11:25:39 AM	Symbolizing	103024	0.00016	Map.Draw
VERBOSE	Jun 23, 2017, 11:25:39 AM	Execute Query	103024	0.03336	Map.Draw
VERBOSE	Jun 23, 2017, 11:25:40 AM	Beginning of layer draw: المناطق المغطاة بالأنظمة المعتمدة	103000		Map.Draw
VERBOSE	Jun 23, 2017, 11:25:40 AM	End of layer draw: وادي السلي	103001	0.23067	Map.Draw
VERBOSE	Jun 23, 2017, 11:25:40 AM	Number of features drawn: 2	103019	0	Map.Draw
VERBOSE	Jun 23, 2017, 11:25:40 AM	Symbol Drawing	103023	0.00572	Map.Draw
VERBOSE	Jun 23, 2017, 11:25:40 AM	Data Access	103024	0.18493	Map.Draw
VERBOSE	Jun 23, 2017, 11:25:40 AM	Symbolizing	103024	0.00007	Map.Draw
VERBOSE	Jun 23, 2017, 11:25:40 AM	Execute Query	103024	0.03781	Map.Draw
VERBOSE	Jun 23, 2017, 11:25:40 AM	Beginning of layer draw: وادي السلي	103000		Map.Draw
VERBOSE	Jun 23, 2017, 11:25:40 AM	End of layer draw: حنيفة وروافده	103001	6.09187	Map.Draw
VERBOSE	Jun 23, 2017, 11:25:40 AM	Number of features drawn: 5	103019	0	Map.Draw
VERBOSE	Jun 23, 2017, 11:25:40 AM	Symbol Drawing	103023	0.00146	Map.Draw
VERBOSE	Jun 23, 2017, 11:25:40 AM	Data Access	103024	0.59812	Map.Draw
VERBOSE	Jun 23, 2017, 11:25:40 AM	Symbolizing	103024	0.00016	Map.Draw
VERBOSE	Jun 23, 2017, 11:25:40 AM	Execute Query	103024	0.04012	Map.Draw
VERBOSE	Jun 23, 2017, 11:25:56 AM	End of layer draw: حرم خط الغاز	103001	0.01711	Map.Draw
VERBOSE	Jun 23, 2017, 11:25:56 AM	Number of features drawn: 1	103019	0	Map.Draw
VERBOSE	Jun 23, 2017, 11:25:56 AM	Symbol Drawing	103023	0.00211	Map.Draw
VERBOSE	Jun 23, 2017, 11:25:56 AM	Data Access	103024	0.00277	Map.Draw
VERBOSE	Jun 23, 2017, 11:25:56 AM	Symbolizing	103024	0.00009	Map.Draw
VERBOSE	Jun 23, 2017, 11:25:56 AM	Execute Query	103024	0.01081	Map.Draw
VERBOSE	Jun 23, 2017, 11:25:56 AM	Beginning of layer draw: حرم خط الغاز	103000		Map.Draw
VERBOSE	Jun 23, 2017, 11:25:56 AM	End of layer draw: المناطق المغطاة بالأنظمة المعتمدة	103001	16.49729	Map.Draw
VERBOSE	Jun 23, 2017, 11:25:56 AM	Number of features drawn: 1546	103019	0	Map.Draw
VERBOSE	Jun 23, 2017, 11:25:56 AM	Symbol Drawing	103023	0.27281	Map.Draw
VERBOSE	Jun 23, 2017, 11:25:56 AM	Data Access	103024	16.02848	Map.Draw
VERBOSE	Jun 23, 2017, 11:25:56 AM	Symbolizing	103024	0.0375	Map.Draw
VERBOSE	Jun 23, 2017, 11:25:56 AM	Execute Query	103024	0.10768	Map.Draw
FINE	Jun 23, 2017, 11:25:57 AM	REST request successfully processed. Response size is 197605 characters.	100004	22.98171	/export
FINE	Jun 23, 2017, 11:25:57 AM	End ExportMapImage	10011	22.98007	MapServer.ExportMapImage
VERBOSE	Jun 23, 2017, 11:26:08 AM	Beginning of layer draw: حنيفة وروافده	103000		Map.Draw
VERBOSE	Jun 23, 2017, 11:26:08 AM	End of layer draw: الأحياء	103001	0.00095	Map.Draw
VERBOSE	Jun 23, 2017, 11:26:08 AM	Number of features drawn: 0	103019	0	Map.Draw
VERBOSE	Jun 23, 2017, 11:26:08 AM	Symbol Drawing	103023	0	Map.Draw
VERBOSE	Jun 23, 2017, 11:26:08 AM	Data Access	103024	0	Map.Draw
VERBOSE	Jun 23, 2017, 11:26:08 AM	Symbolizing	103024	0	Map.Draw
VERBOSE	Jun 23, 2017, 11:26:08 AM	Execute Query	103024	0	Map.Draw
VERBOSE	Jun 23, 2017, 11:26:08 AM	Beginning of layer draw: الأحياء	103000		Map.Draw
VERBOSE	Jun 23, 2017, 11:26:08 AM	End of preparation.	10095	0.00081	MapServer.ExportMapImage
VERBOSE	Jun 23, 2017, 11:26:08 AM	Begining of preparation.	10094		MapServer.ExportMapImage
FINE	Jun 23, 2017, 11:26:08 AM	Extent:655297.980760,2732504.177465, 679139.822770,2743012.811597; Size:1366,592; Scale:72223.82	10138
FINE	Jun 23, 2017, 11:26:08 AM	Begin ExportMapImage	10010		MapServer.ExportMapImage
FINE	Jun 23, 2017, 11:26:08 AM	REST request received. Request size is 179 characters.	100001		/export
VERBOSE	Jun 23, 2017, 11:26:09 AM	Number of features drawn: 4	103019	0	Map.Draw
VERBOSE	Jun 23, 2017, 11:26:09 AM	Symbol Drawing	103023	0.00003	Map.Draw
VERBOSE	Jun 23, 2017, 11:26:09 AM	Data Access	103024	0.62609	Map.Draw
VERBOSE	Jun 23, 2017, 11:26:09 AM	Symbolizing	103024	0.00012	Map.Draw
VERBOSE	Jun 23, 2017, 11:26:09 AM	Execute Query	103024	0.14973	Map.Draw
VERBOSE	Jun 23, 2017, 11:26:10 AM	Number of features drawn: 4	103019	0	Map.Draw
VERBOSE	Jun 23, 2017, 11:26:10 AM	Symbol Drawing	103023	0.00002	Map.Draw
VERBOSE	Jun 23, 2017, 11:26:10 AM	Data Access	103024	0.63097	Map.Draw
VERBOSE	Jun 23, 2017, 11:26:10 AM	Symbolizing	103024	0.0001	Map.Draw
VERBOSE	Jun 23, 2017, 11:26:10 AM	Execute Query	103024	0.08496	Map.Draw
VERBOSE	Jun 23, 2017, 11:26:11 AM	Number of features drawn: 4	103019	0	Map.Draw
VERBOSE	Jun 23, 2017, 11:26:11 AM	Symbol Drawing	103023	0.00004	Map.Draw
VERBOSE	Jun 23, 2017, 11:26:11 AM	Data Access	103024	0.5949	Map.Draw
VERBOSE	Jun 23, 2017, 11:26:11 AM	Symbolizing	103024	0.00015	Map.Draw
VERBOSE	Jun 23, 2017, 11:26:11 AM	Execute Query	103024	0.14694	Map.Draw
VERBOSE	Jun 23, 2017, 11:26:11 AM	Number of features drawn: 4	103019	0	Map.Draw
VERBOSE	Jun 23, 2017, 11:26:11 AM	Symbol Drawing	103023	0.005	Map.Draw
VERBOSE	Jun 23, 2017, 11:26:11 AM	Data Access	103024	0.71727	Map.Draw
VERBOSE	Jun 23, 2017, 11:26:11 AM	Symbolizing	103024	0.00058	Map.Draw
VERBOSE	Jun 23, 2017, 11:26:11 AM	Execute Query	103024	0.16438	Map.Draw
VERBOSE	Jun 23, 2017, 11:26:12 AM	Number of features drawn: 4	103019	0	Map.Draw
VERBOSE	Jun 23, 2017, 11:26:12 AM	Symbol Drawing	103023	0.0068	Map.Draw
VERBOSE	Jun 23, 2017, 11:26:12 AM	Data Access	103024	0.57387	Map.Draw
VERBOSE	Jun 23, 2017, 11:26:12 AM	Symbolizing	103024	0.00013	Map.Draw
VERBOSE	Jun 23, 2017, 11:26:12 AM	Execute Query	103024	0.04249	Map.Draw
VERBOSE	Jun 23, 2017, 11:26:13 AM	Number of features drawn: 4	103019	0	Map.Draw
VERBOSE	Jun 23, 2017, 11:26:13 AM	Symbol Drawing	103023	0.00277	Map.Draw
VERBOSE	Jun 23, 2017, 11:26:13 AM	Data Access	103024	0.58482	Map.Draw
VERBOSE	Jun 23, 2017, 11:26:13 AM	Symbolizing	103024	0.00015	Map.Draw
VERBOSE	Jun 23, 2017, 11:26:13 AM	Execute Query	103024	0.03063	Map.Draw
VERBOSE	Jun 23, 2017, 11:26:13 AM	Number of features drawn: 4	103019	0	Map.Draw
VERBOSE	Jun 23, 2017, 11:26:13 AM	Symbol Drawing	103023	0.00003	Map.Draw
VERBOSE	Jun 23, 2017, 11:26:13 AM	Data Access	103024	0.58812	Map.Draw
VERBOSE	Jun 23, 2017, 11:26:13 AM	Symbolizing	103024	0.00018	Map.Draw
VERBOSE	Jun 23, 2017, 11:26:13 AM	Execute Query	103024	0.03667	Map.Draw
VERBOSE	Jun 23, 2017, 11:26:14 AM	Number of features drawn: 4	103019	0	Map.Draw
VERBOSE	Jun 23, 2017, 11:26:14 AM	Symbol Drawing	103023	0.00433	Map.Draw
VERBOSE	Jun 23, 2017, 11:26:14 AM	Data Access	103024	0.59016	Map.Draw
VERBOSE	Jun 23, 2017, 11:26:14 AM	Symbolizing	103024	0.00015	Map.Draw
VERBOSE	Jun 23, 2017, 11:26:14 AM	Execute Query	103024	0.02971	Map.Draw
VERBOSE	Jun 23, 2017, 11:26:15 AM	End of layer draw: وادي	103001	0.17967	Map.Draw
VERBOSE	Jun 23, 2017, 11:26:15 AM	Number of features drawn: 1	103019	0	Map.Draw
VERBOSE	Jun 23, 2017, 11:26:15 AM	Symbol Drawing	103023	0.00276	Map.Draw
VERBOSE	Jun 23, 2017, 11:26:15 AM	Data Access	103024	0.15937	Map.Draw
VERBOSE	Jun 23, 2017, 11:26:15 AM	Symbolizing	103024	0.00004	Map.Draw
VERBOSE	Jun 23, 2017, 11:26:15 AM	Execute Query	103024	0.01537	Map.Draw
FINE	Jun 23, 2017, 11:26:19 AM	REST request successfully processed. Response size is 252896 characters.	100004	10.32033	/export
FINE	Jun 23, 2017, 11:26:19 AM	End ExportMapImage	10011	10.31943	MapServer.ExportMapImage
FINE	Jun 23, 2017, 11:26:27 AM	Begin ExportMapImage	10010		MapServer.ExportMapImage
FINE	Jun 23, 2017, 11:26:27 AM	REST request received. Request size is 179 characters.	100001		/export
FINE	Jun 23, 2017, 11:26:27 AM	Extent:664037.369389,2736947.981827, 669997.575335,2739574.970418; Size:1366,592; Scale:18055.95	10138
FINE	Jun 23, 2017, 11:26:34 AM	REST request successfully processed. Response size is 142644 characters.	100004	7.23262	/export
FINE	Jun 23, 2017, 11:26:34 AM	End ExportMapImage	10011	7.23177	MapServer.ExportMapImage
FINE	Jun 23, 2017, 11:26:39 AM	REST request received. Request size is 178 characters.	100001		/export
FINE	Jun 23, 2017, 11:26:39 AM	Extent:666072.976361,2737343.384273, 669053.190971,2738657.018988; Size:1366,592; Scale:9027.98	10138
FINE	Jun 23, 2017, 11:26:39 AM	Begin ExportMapImage	10010		MapServer.ExportMapImage
FINE	Jun 23, 2017, 11:26:46 AM	End ExportMapImage	10011	6.85495	MapServer.ExportMapImage
FINE	Jun 23, 2017, 11:26:46 AM	REST request successfully processed. Response size is 127129 characters.	100004	6.856	/export

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

RandallWilliams — Fri, 23 Jun 2017 15:20:58 GMT

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.

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

ElieRizk — Mon, 03 Jul 2017 12:20:40 GMT

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.

topic GIS layer slow performance in arcgis server 10.3, using oracle sde in ArcGIS Enterprise Questions

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

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

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

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

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

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