Hello:
I currently work with VRP services (vehicle routing problem) in ArcGIS Server 10.3, these services work with file geodatabase; these geodatabase files were migrated to a corporate geodatabase in SQL Server 2012, publishing said service again with instances to the geodatabase in SQL Server, taking into account that the service performance would improve, as well as the times of publication since with the file The published geodatase took around 7 to 8 hours (this is due to the process performed by the entire database copy tool at the time of building the service). The problem arose at the time of sending the requests to the service which normally takes between 10 to 20 seconds and already with the data migration takes between 10 to 15 minutes taking as examples the same parameters between both service, as well as the server performance where ArcGIS Server is hosted and SQL Server 2012 rises to its limits in memory and CPU processes.
