ArcGIS Pro performance issues

JimGarcia1

We occasionally are having issues of ArcGIS Pro. We have certain layers in our enterprise database that take forever to load. Sometimes they load quickly, and editing is quick and easy, and at other times, it can loop forever and ever to load. We re-set the server, but that doesn't seem to do anything. And then the next day, or even a few hours later in the same day, it works again. Also, it seems to be the layers in a specific dataset, so I am assuming something at the Feature Dataset level? 

Melissa_B

Are the layers being accessed directly through something like an SDE connection or are they Portal services that you are referencing in the project?  If it's portal services, then it sounds like a cold start issue - depending on how the service is configured, if there's not one constant background instance sitting on the server at all times, then when the service is queried, it has to load up the instance on request which takes a bit.  The shared versus dedicated instance pools and the minimum number of instances have to be tuned to balance memory usage on the server and speed: https://www.esri.com/arcgis-blog/products/arcgis-enterprise/administration/shared-instances-arcgis-server-107

It might also be related to database maintenance tasks - rebuilding indexes and analyzing statistics for the database and the datasets within it, reconciling versions, and compressing the database. https://desktop.arcgis.com/en/arcmap/10.5/manage-data/geodatabases/recommended-version-administration-workflow.htm