We have moved our ArcMap/Pro to Azure while the SQL and Oracle databases are still in a local datacenter. Performance when connecting, viewing and exporting database tables is terrible now. Any other system admins with a similar setup https://mobdro.bio/ ?
This would be expected. We recommend having the clients in the same location as the databases: https://enterprise.arcgis.com/en/system-requirements/latest/windows/databases-in-the-cloud.htm, for Desktop: https://desktop.arcgis.com/en/system-requirements/latest/databases-in-the-cloud.htm
Connections from ArcGIS software to databases or data warehouses in the cloud must originate from machines in the same cloud. For best performance, connections should originate from machines in the same cloud region. In the majority of cases, connection and query performance is poor when you connect from ArcGIS clients installed on-premises to databases or data warehouses in the cloud, connect from ArcGIS clients in the cloud to databases or data warehouses on-premises, or make connections between clients and databases or data warehouses in different cloud regions. In these scenarios, connections to the database may time out.
Why did you move the clients (ArcGIS Pro) and not the databases / Enterprise to the cloud?
I am just curious.....