It seems as though all of my feature services have slowed down so much that they are almost impossible to use. I am pulling them from server/rest. Does anyone have any suggestions?
In order for someone to assist, we'll need to understand some details. There are many potential causes for performance issues.
A. Which version ArcGIS?
B. Are you using the full Enterprise stack, with Portal for ArcGIS?
C. If so, are these hosted feature services with Data Store as the data source?
D. If not, what RDBMS are you using?
E. What volume of traffic are you experiencing? Are some services more heavily used than others?
F. On which platform (windows/linux) is your Server, Portal, or DBMS hosted?
G. What's the specs on each machine?
H. How many services do you have published?
I. Are map services with the same data published from a file based data source faster?
J. Your question implies that services were once faster. To your knowledge, what changed?
K. Are some feature services fast and others slow?
Depending on your answers, there may be additional questions. This could be a resource issue on the GIS Server, a resource issue on the database server, a network issue, your database may need a compress and/or reindex, some inefficient query.
Randall thank you for your reply.
b. We do not use portal
c not sure
d not sure
e traffic is minimal
g not sure
j nothing has changed except arcgis online has updated with clustering, but i do not quite understand what that is.
k some feature services are faster than others, but all have seemed to slow.
The feature services run fast on collector, but on on agol or in any web apps. Sorry for my limited knowledge. We use amazon for our server.Thank you for your help.
Your answer to 'i' leads me to think that this is some kind of DBMS issue - either network or general performance. Since file based data seems fast, we can at this point narrow this down to the data tier.
Since you're on Amazon EC2, you're using either SQL Server, SQL Express or PostGREs. To your knowledge, is everything (database/GIS Server) hosted on the same machine?
Are you able to reach the machine via remote desktop?
Sql express, and to the best of my knowledge everything is hosted on the same machine. Yes we are able to reach via remote.
Hi Randall, Do you have any suggestions for troubleshooting? Thanks
Sorry for the delay. There isn't really a one size fits all solution for a performance type issue, but we can focus on the geodatabase to start, as that's the likely bottleneck.
The first thing I'd do would be to run a reconcile, post, compress, and reindex on your geodatabase.
I think it would also benefit you to review the following resources:
Also, the 'additional resources' slide at the end of this presentation will be helpful to come up with metrics to better understand the root of the issue:
Retrieving data ...