In the past, I was able to execute SQL queries remotely (external to the Azure environment) with good performance that was fairly comparable to a local database.
Sometime within the last many months, it has suddenly become very slow compared to previous performance. In addition, I don't see the same kinds of issues with SSMS with remote access.
This is happening with applications that use the older ADO.NET datasets and Entity Framework for .NET Framework. We are also using SQL auth and not AD. The SQL databases have plenty of available DTUs and are not overloaded and there are no issues with Azure-hosted apps.
What is the cause of this? Could there be something that is reducing the previous bandwidth or a new security mechanism that is introducing latency?
Thank you in advance for any advice on this issue.