双Xeon机器性能不佳 [英] Poor Performance on Dual Xeon Machine
问题描述
我一直在使用MS Access和MSDE创建数据库应用程序。我们只有两个人使用该应用程序，服务器和应用程序都在我的笔记本电脑上运行了很好的价格（1.6 GHz Pentium M，2GB RAM，W2KPro）。唯一的问题
是当我把笔记本电脑带回家时，我的同事失去了对服务器的访问权。
我们最近购买了一台专用服务器来运行数据库
办公室。它是2.8 GHz双Xeon，2GB RAM，运行XPPro。我们还买了
购买了SQL Server，但是我安装了个人版，因为我们不是使用服务器操作系统而是b $ b。我的理解是XP可以同时使用两个
处理器，个人版也可以同时使用两个处理器。
（旁注，为什么是企业管理器显示我有4个
处理器 - 为什么？）此外，我了解PE有一个工作负载
调控器，当超过5个TSQL命令时，它会削弱性能/>
同时运行。
我在笔记本电脑上备份数据库并在新服务器上恢复它。但是当我运行具有完全相同行数的完全相同的查询时，
，
我在新服务器上的查询需要花费3倍的时间（！？）。可以有人
请提供一些建议，说明为什么会发生这种情况？我可以用什么来提高服务器机器的性能？
如果需要提供更多信息，请告诉我。
谢谢，
Alex
Hi,
I''ve been creating a db application using MS Access and MSDE. Only two
of us are using the application, and the server and the app both run
great on my laptop (1.6 GHz Pentium M, 2GB RAM, W2KPro). Only problem
is when I take my laptop home, my coworker loses access to the server.
We recently purchased a dedicated server to run the db on at the
office. It''s a 2.8 GHz Dual Xeon, 2GB RAM, running XPPro. We also
bought SQL Server, but I installed the Personal Edition becuase we are
not using a server OS. It''s my understanding that XP can utilize both
processors, and the Personal Edition can use both processors as well.
(On a side note, why is Enterprise Manager showing that I have 4
processors - why?) In addition, I understand PE has a work-load
governor that cripples performance when more than 5 TSQL commands are
being run simultaneously.
I backed up the db on my laptop and restored it on our new server. But
when I run the exact same queries with the exact same number of rows,
my queries on the new server are take 3x longer(!?). Can someone
please offer a few suggestions for why this is happening? What can I
do to improve performance on the server machine?
Please let me know if I need to supply more information.
Thanks,
Alex
推荐答案
>>>我们最近购买了专用服务器在
办公室运行数据库。它是2.8 GHz双Xeon，2GB RAM，运行XPPro
XPPro，你应该安装Developer Edition而不是PE，这是用于
笔记本电脑。
>>>We recently purchased a dedicated server to run the db on at the
office. It''s a 2.8 GHz Dual Xeon, 2GB RAM, running XPPro
You really should install a Server OS not XPPro. If you''re stuck with
XPPro, you should install Developer Edition not PE, which is meant for
laptops.
在旁注中，为什么企业管理器显示我有4
处理器 - 为什么？
在Pentium 4超线程出现之前编写了MSSQL 2000。这个2
芯片的软件显示为4。
我在笔记本电脑上备份数据库并在我们的新服务器上恢复它。
On a side note, why is Enterprise Manager showing that I have 4 processors - why?
MSSQL 2000 was written before Pentium 4 hyperthreading came out. The 2
chips appears as 4 to the software.
I backed up the db on my laptop and restored it on our new server.
但是当我使用完全相同数量的
行运行完全相同的查询时，我在新服务器上的查询需要花费3倍的时间（！？） 。
尝试运行sp_updatestats。
But when I run the exact same queries with the exact same number of
rows, my queries on the new server are take 3x longer(!?).
Try running sp_updatestats.
路易斯，
我们有MSSQL标准版本（包括个人和MSDE），以及
暂时我们有XPPro。
在我看来，我正在运行一个非常好的
服务器上的类似配置与笔记本电脑上的相似。如果
不比MSDE好一点，PE的表现应该差不多;与W2kPro上的XPPro相同。
我尝试更新统计数据;这没有任何影响。
我也一直在使用性能监视器而且没有找到任何与众不同的东西。我正在使用的简单选择查询
两台机器之间的基准测试无法访问物理磁盘
。
Alex
Louis,
We have MSSQL Standard Edition (which includes Personal and MSDE), and
for the time being we have XPPro.
It seems to me that I''m running a very similar configuration on the
server to what I am on my laptop. PE should perform about the same if
not a little better than MSDE; same w/ XPPro over W2kPro.
I tried updating the statistics; that had no effect.
I''ve also been using the performance monitor a little and haven''t found
anything out of the ordinary; the simple select queries I''m using as
benchmarks between the two machines are not accessing the physical disk
on either.
Alex
我怀疑性能监视器会说多少 - 因为新服务器
不应该有任何硬件瓶颈。更有可能的是，它必须以机器上配置/设置MSSQL的方式来执行
。 （事实上，这是一个拥有MSSQL PE的XP专业人士）。执行计划说了什么？
I doubt performance monitor will say much -- as the new server
shouldn''t have any hardware bottlenecks. More likely, it has to do
with the way MSSQL is configured/setup on the machine. (And the fact
it''s XP professional with MSSQL PE). What does the execution plans say?
这篇关于双Xeon机器性能不佳的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
