Improve performance of MapService

Question

Hi Community, We have a map service (with feature access enabled) which is loading intermittently in map viewer of Portal. Following are the details of the environment & troubleshooting performed so far: * Single machine base deployment (10.8.1) * Referenced map service from SQL Server Geodatabase. * The map service has around 12 layers and contains around 500,000 records. * Memory of the machine (RAM) is around 60 GB. * Datastores validating successfully in server manager * Permissions are in place for the service account * Service has a dedicated instance (min1 and max2) * It was observed that the REST end point of the service was opening however, on performing the query operation was getting error message of Error performing query operation. * Following are the error messages that are coming in the logs:* Failed to construct of service service startup timeout. * Error performing query operation. Error handling service request. Service startup timeout. * Error Exporting Map. Wait time of the request to the service has expired. * Observed that local drives where server directory is present has sufficient space. * Following the steps mentioned in the article: https://support.esri.com/en-us/knowledge-base/error-performing-query-operation-1462482758126-000011736 increased the heap size from 64 MB to 128 MB however, still the intermittent issue is there. * Increased the setting of The maximum time a client will wait to get a service from 60 to 120 seconds however, we are still facing the issue. Any suggestions on how to improve the performance of the service would be greatly appreciated.

ahoque · Answer

@wizgis

I'd strongly recommend you to reach out to Esri support on this. It shouldn't get timed out while starting up.

berniejconnors · Answer

wizgis,

I agree with @JoshuaBixby. You should look to optimize your data in ArcGIS Pro.

Additionally, you should look into how much load the server is expereincing.  Is the RAM or CPU maxed out during times when you see these problems?  If not, I would recommend trying to increase the min and max instances.  Timeouts could indicate there is not an instance available and requests are waiting too long in a queue.  More instances could alleviate the problem.  But you should look to optimize your layers as well.

How many services have you published?  Do you just have the one service with 12 layers?  If that is the case I would definitely split your layers across multiple services as suggested by @RPGIS .

Bernie.

JoshuaBixby · Answer

Optimizing a map service starts in ArcGIS Pro.  ArcGIS Enterprise uses the same rendering engines as ArcGIS Pro, so anything that is slow to open and slow to render in Pro will be slow to start and slow to respond in ArcGIS Enterprise.  Taking ArcGIS Enterprise out of the equation to start helps focus on data and map structure issues that negatively impact performance.  Once the map is opening and rendering quickly in Pro, then start looking at publishing it and potentially optimizing service-related settings.