如何使用链接服务器避免 preemptive_oledbos SQL Server 2008
我们有两台 SQL Server，并将它们设置为链接服务器。有一种特殊的存储过程，在运行时必须将链接服务器中的表连接到它自己的表。通常情况下，这似乎需要很长时间，经过一番查看后，似乎在活动监视器中它得到了“PREEMPTIVE_OLEDBOPS”。但这仅适用于从 ASP.NET 调用 SP 时。当我在 SQL Server Management Studio 中运行查询时，查询每次都会在 6 秒内运行。
我不是 dba - 所以我的知识非常肤浅。谷歌搜索此错误代码，表明它是一个等待代码，但我无法获得有关如何避免它们或到底是什么导致它的任何信息。
感谢您的帮助， ～P
We have two SQL Servers and have them set up as linked servers. There is one particular stored procedure that when run has to join tables from the linked server to it's own. Often times it seems to take forever and after looking a bit, it seems that in activity monitor it gets a "PREEMPTIVE_OLEDBOPS". But this is only when the SP is called from ASP.NET. When I run the query in SQL Server Management Studio the query runs in 6 seconds - everytime.
I am not a dba - so my knowledge here is pretty superficial. Googling for this error code, suggests it's a wait code, but I couldn't get any information about how to avoid them or what exactly is causing it.
Thanks for any help,
~P
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
尝试调整您的 sp 以使用 OPENQUERY 命令。
Try adapting your sp to use OPENQUERY command.