性能为何不同？ [英] Why the performace differs?
问题描述
全部，
我有关于SQL Server 2000 SP3的问题，
我有SP调用其他SP并且它插入大约30,000条记录作为
时间，
开发环境中的
（MS Windows 2003企业版，256 RAM，
但是，使用相同的软件，但2.6 GHz英特尔和1 GB Ram，它运行
非常慢，运行时间超过135秒，
我已经阅读了很多关于扩展SQL内存的文章，并给予
更高的进程权限，但没有用，
我不知道问题出在哪里，你对这个问题有什么想法吗？
谢谢你提前，
MAG
All,
I have a problem regarding SQL Server 2000 SP3,
I have SP that calls other SP and it inserts about 30,000 records as a
time,
in the development environment (MS Windows 2003 Enterprise, 256 RAM,
3.0 GHz Intel Processor) takes about 6 seconds to run this SP.
But, with the same Software but, 2.6 GHz Intel and 1 GB Ram, it runs
very slow it takes more than 135 Seconds to run,
I have read a lot of articles about expanding the SQL Memory and give
it a higher process privilege but, with no use,
I don''t know where the problem is, do you have any idea about what is
the problem?
Thank you in advance,
MAG
推荐答案
请检查在系统上运行的另一个进程。
只需执行任务管理器，看看什么是utilizin那个记忆。
最好的问候，
Chandra
http://www.SQLResource.com/
http://chanduas.blogspot.com/
---------------------------- -----------
***通过Developersdex发送 http://www.developersdex.com ***
Please check the other processess that are running on the system.
Just execute the task manager and see what is utilizing that memory.
best Regards,
Chandra
http://www.SQLResource.com/
http://chanduas.blogspot.com/
---------------------------------------
*** Sent via Developersdex http://www.developersdex.com ***
是的，SQL Server具有最高的优势，消耗大约800MB <来自内存的
（我通过从
企业管理器配置SQL Server来实现这一点）
但仍然非常慢。 br />
***通过开发人员指南 http://www.developersdex.com ***
Yes, SQL Server is having the highest piority and consumes about 800MB
from the memory (I made this by configure the SQL Server from the
Enterprise Manager)
but still very slow.
*** Sent via Developersdex http://www.developersdex.com ***
" Mohamed Gad" <莫********* @ gmail.com>在消息中写道
新闻：YP ************ @ news.uswest.net ...
"Mohamed Gad" <mo*********@gmail.com> wrote in message
news:YP************@news.uswest.net...
是的，SQL Server正在使用内存最高，消耗大约800MB（我通过从企业管理器配置SQL Server来实现这一点）
是否启用了日志记录并且其他不是吗？
磁盘子系统怎么样？
这很可能是阻塞点。
但仍然很慢。
***通过Developersdex发送 http://www.developersdex.com ***
Yes, SQL Server is having the highest piority and consumes about 800MB
from the memory (I made this by configure the SQL Server from the
Enterprise Manager)
Does one have logging enabled and the other doesn''t?
What about the disk subsystem?
That''s most likely the chokepoint.
but still very slow.
*** Sent via Developersdex http://www.developersdex.com ***
这篇关于性能为何不同？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
