性能问题MS SQL 2019和OLEDB
我们将客户数据库服务器从MS SQL Server 2012迁移到MS SQL Server 2019。
还有一个链接服务器，从IBM/DB2数据库中获取数据。借助MS SQL Server 2012，从链接服务器获得10行的时间不到1秒钟。使用MS SQL Server 2019，需要20秒或更长时间！
如果我将记录数增加到100/1000，则将立即显示结果，但是查询的状态为“执行” 20秒。
如何解决此问题，因此SQL Server 2019将能够无需延迟即可有效地使用链接服务器？
We migrated a customer DB server from MS SQL Server 2012 to MS SQL Server 2019.
There is also a linked server, fetching data from an IBM/DB2 database. With MS SQL Server 2012 it took less than 1 second to get 10 rows from the linked server. With MS SQL Server 2019 it takes 20 seconds or more!
If I increase the number of records to 100/1000 the result is displayed immediately, but the query has status "executing" for 20 seconds.
How can I resolve this, so SQL Server 2019 will be able to effectively use the linked server without delays?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（2）
客户已经确认，在将OLEDB驱动程序降级为DB/2 V5.0之后，性能与旧系统一样好。
https://www.microsoft.com/en-en-us/ download/lidets.aspx？id = 55183
The customer has confirmed, that after downgrading the OLEDB Driver for DB/2 v5.0 the performance is as good as on the old system.
https://www.microsoft.com/en-us/download/details.aspx?id=55183
我可能有一个解决方案。当我将SQL Server从Windows 2008R2 SQL 2008移至Windows 2022时，我遇到了重大性能问题。有一天，我偶然发现了解决方案。听起来它会无关，但是请相信我，它将改善您的SQL Server性能。
在SQL Server上打开一个高架的PowerShell提示，并在以下内容中粘贴：
这将告诉Windows Server不要在服务器上的油门带宽。
I may have a solution for you. I had major performance issues when I moved my SQL server from Windows 2008R2 SQL 2008 to Windows 2022 with SQL 2019. I stumbled upon a solution one day. It sounds like it would be unrelated, but trust me, it will improve your SQL server performance.
Open an elevated PowerShell prompt on the SQL server and paste in the following:
This will tell Windows server NOT to throttle bandwidth on the server.