NYSDOT found an intermittent performance bug with our Roads and Highways Enterprise Geodatabse (10.5.1). The issue manifested itself when attempting to use snapping in an edit session. Rather than snap to the appropriate feature, ArcGIS would present a loading icon and never really "snapped".
We were able to track this down to a database issue, and the R&H team helped submit a bug report to the ArcGIS geodatabase team. There's been some movement on the issue, so we wanted to share it with the RHUG community. Here's the system generated email:
The status of Esri BUG-000118270 - Extreme latency in snapping until a feature cache is created. - that you have been associated with has been changed to Not in Current Product Plan.