Data download from AS400 Slower in 2019 than 2008

Question

I have a linked server to our AS400 system via ODBC driver, same driver is used for SQL 2008 and 2019, the Same download job which runs in 3 seconds on 2008 runs on 2019 for 24 seconds.
only differences between the two servers are OS 2008 SQL is running on 2007 Windows Server and 2019 SQL is running on 2019 windows Server. I had this same slowness when running 2012 SQL server on 2012 R2 Windows Server. It seems the downloads just can't match the times on the oldest version, despite being better servers with more CPU and Memory.
ODBC connection is the same, driver version the same, but nothing i try seems to improve the download speed on the newer version of SQL.

Any suggestions on how to resolve?

Answer 1

Hi @HK ,

Welcome to Microsoft Q&A!

May I ask that is it just slow to download or it is also slow to run queries? If it is also slow to run queries, I suggest that please make performance test for SQL Server. You could make SQL Performance Tuning. There have some ways that you could find what makes SQL Server slow.

Best regards,
Carrin

---

If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.