Why do some services in an enterprise geodatabase require longer process time within ArcGIS Pro?

Answer

In ArcGIS Pro, edits made to services added from an enterprise geodatabase (.sde) may take a longer time to process. There are various reasons for this besides network or VPN connection disparities, which collectively contribute to prolonged processing times. This article describes common performance issues associated with the client (ArcGIS Pro and ArcGIS Enterprise). Issues pertaining to the database must be dealt with internally, within the user's organization, as it falls out of Esri's scope of support. Refer to Technical Support: Scope of Support for more info.

One common factor is large datasets. Although the services are contained within an enterprise geodatabase, editing requires resources from the machine. The machine running or connected to ArcGIS Enterprise must adhere to the minimum requirements set for installation. For more information, refer to ArcGIS Pro: ArcGIS Pro 3.2 system requirements. Optionally, reduce the size of the datasets by removing unnecessary attributes. For more information, refer to ArcGIS Pro: Reduce data size.

This issue may also arise due to the complexity of the datasets, which can affect the performance of the web tool services. There are tips and techniques to increase service performance by simplifying the service to avoid overloading the server. Refer to ArcGIS Pro: Web tool performance tips for methods to increase service performance. Another option is to generalize the datasets using partitions. This method is optimal when there are a large number of complex features with attributes, as it allows geoprocessing tools to run on the partitioned data sequentially. For more information refer to ArcGIS Pro: Generalizing large datasets using partitions.

Additionally, the number of service instances set in ArcGIS Server may contribute to the issue. Increase the number of instances allocated to the service to enhance the response speed. For more information, refer to ArcGIS Server: Configure service instance settings. However, provisioning more server resources than a service requires takes up valuable computer memory and energy. It also dampens the performance of other services if there are insufficient instances allocated to them. Esri recommends setting the number of service instances to optimum to avoid affecting performance.