Sudden connection performance degredation

Peter Vos (Admin) 0

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!

KapilAnanth-MSFT 35,591 Reputation points Microsoft Employee

2023-06-01T15:53:11.6866667+00:00
@Peter Vos (Admin)

Welcome to the Microsoft Q&A Platform. Thank you for reaching out & I hope you are doing well.

I see that you have tagged Azure VPN Gateway here.

Do you have multiple SQL Servers on Azure?

You have mentioned a VM running Windows 2016, Azure SQL server and OnPrem devices.

From where to where the query is running?

From the VM to Azure SQL ?

or from local Onprem servers to Azure SQL?

Or something else?

Can you please elaborate more on your network architecture please?

Thanks,

Kapil
ZoeHui-MSFT 33,296 Reputation points

2023-06-02T08:33:16.9466667+00:00

Hi @Peter Vos (Admin),

Could you please re-deploy the package to the server for a try.

Are you using proxy account to run the job? Make sure that the account used to run the job have full permission to your source or destination.

You may also enable logging in the package to get more information to analyze.

Regards，

Zoe Hui

If the answer is helpful, please click "Accept Answer" and upvote it.
KapilAnanth-MSFT 35,591 Reputation points Microsoft Employee

2023-06-05T10:38:47.8+00:00

@Peter Vos (Admin)

Can you please update us if the action plan provided was helpful?

Should there be any follow-up questions or concerns, please let us know and we shall try to address them.

Thanks,

Kapil
KapilAnanth-MSFT 35,591 Reputation points Microsoft Employee

2023-06-06T17:35:27.3566667+00:00

@Peter Vos (Admin)

May I know if you got a chance to review my previous comment?

Please let me know if you are facing any challenges or if there are any follow-up questions, I shall be glad to address them.

Thanks,

Kapil