sql server性能突然变慢了。 [英] sql server performance got slow down suddenly.

问题描述

你好朋友......



我在Windows Server 2008 r2上使用sql server 2008。它包含一个名为'muri'的数据库。我使用iHistorian OLE DB Provider为proficy历史记录创建了一个链接服务器。我为链接服务器执行了一些查询。它工作很好，直到早上。

当我运行简单的查询后。

hello Friends...

i m using sql server 2008 on windows server 2008 r2. it contains a database named 'muri'. and i have created a linked server to proficy historian using iHistorian OLE DB Provider. i executed some query for linked server. It was working Fine till morning.
when i run simple following query.

select * from openquery(ihist,'select * from ihtags')

它一直执行到我关闭了sql server.It需要很长时间但是没有完成执行。首先我认为sql server变慢了。但是当我按照以下方式对我的muri数据库运行简单查询时。

it went executing until i close the sql server.It takes long time but don't complete execution. first i thought sql server went slow down. but when i run simple query to my muri database as follows.

select * from employee

它运作完美。在那之后我试图删除现有的链接服务器，这也显示了正在执行的进度但是没有完成执行和删除。

然后我试图创建具有不同名称的新链接服务器，同样的事情发生在这另外。

它无法删除现有的链接服务器，无法创建新的链接服务器而无法执行openquery，如下所示

it is working perfect. after that i tried to delete existing linked server, this also showed progress as executing but don't complete execution and deletion.
then i tried to create new linked server with different name, same thing happened with this also.
it can't delete existing linked server,can't create new linked server and can't execute openquery as follows

select * from openquery(ihist,'select * from ihtags')

plz帮助。

谢谢

plz help.
thank you

推荐答案

查询链接服务器将比本地数据慢，直接与您的网络可用性和吞吐量成比例。



如果您只查询数据，请尝试创建数据的本地副本，并定期将其与rem同步ote链接服务器。

Querying a linked server will be slower than local data and is directly proportional to your network availability and throughput.

If you are only querying the data then try creating a local copy of the data and periodically sync it with the remote linked server.

这篇关于sql server性能突然变慢了。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！