Sudden connection performance degredation

Peter Vos (Admin) 0 Reputation points
2023-06-01T15:38:42.23+00:00

Hi,

We have an Azure VM running Windows 2016 with SSIS installed. We retrieve and write data multiple times per day rom om-premise servers to an Azure SQL Server.

Since tuesday morning, queries coming from 2 specific servers (Oracle) and to the SQL-Server timeout after 10 minutes, sometimes only writing 100's of records, or 0 in some cases.

Running these packages from visual studio (Same source and destination) the performance is OK.

We think the issue is somewhere in the line between the VM and the SQL server, or something happening within SSIS. We checked most performance measures, but could not find any indicator of problems.

We are out of ideas at the moment and our org has been without data for ome days now.

Happy to answer any questions of course!

Azure VPN Gateway
Azure VPN Gateway
An Azure service that enables the connection of on-premises networks to Azure through site-to-site virtual private networks.
1,443 questions
Azure VMware Solution
Azure VMware Solution
An Azure service that runs native VMware workloads on Azure.
337 questions
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,286 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,516 questions
{count} votes