When running a very simple query in SQL Server 2000.
在SQL Server 2000中运行非常简单的查询时。
SELECT getDate()
Most queries are sub second, but one query randomally in 10 takes about five seconds.
大多数查询都是次秒,但是10中的一个查询randomally大约需要5秒。
I am running these queries from SQL Server 2008 Management studio, but it occurs in other clients and on other machines as well, so it is not client specific.
我从SQL Server 2008 Management Studio运行这些查询,但它也发生在其他客户端和其他计算机上,因此它不是特定于客户端的。
The query is running to a server which is on the same network and there is no significant load on the server.
查询正在运行到位于同一网络上的服务器,并且服务器上没有显着负载。
Can anyone tell me why this might be happening?
谁能告诉我为什么会这样呢?
2 个解决方案
#1
Sounds like network issues. We had the same thing happen when I worked for a large bank. Due to politics, it was out of our control.
听起来像网络问题。当我在一家大银行工作时,我们遇到了同样的事情。由于政治原因,这是我们无法控制的。
You can do a few things to confirm this, like try running the queries from the server, etc.
您可以做一些事情来确认这一点,例如尝试从服务器运行查询等。
#2
The two things I would suspect without more information right off the bat are network latency and server load. Do you get this behavior when running the query from the database server machine itself? Do you get this behavior when running in single-user mode?
我怀疑没有更多信息的两件事就是网络延迟和服务器负载。从数据库服务器计算机本身运行查询时是否会出现此问题?在单用户模式下运行时是否会出现此问题?
#1
Sounds like network issues. We had the same thing happen when I worked for a large bank. Due to politics, it was out of our control.
听起来像网络问题。当我在一家大银行工作时,我们遇到了同样的事情。由于政治原因,这是我们无法控制的。
You can do a few things to confirm this, like try running the queries from the server, etc.
您可以做一些事情来确认这一点,例如尝试从服务器运行查询等。
#2
The two things I would suspect without more information right off the bat are network latency and server load. Do you get this behavior when running the query from the database server machine itself? Do you get this behavior when running in single-user mode?
我怀疑没有更多信息的两件事就是网络延迟和服务器负载。从数据库服务器计算机本身运行查询时是否会出现此问题?在单用户模式下运行时是否会出现此问题?