提高绩效 [英] Improving performance
问题描述
我在我的开发机器上使用了SQL Server 2005，虽然这台机器并不像现场服务器那么强大，它有时似乎比我预期的要慢一点。所以我一直想知道是否有任何方式让我调整机器，以便SQL Server能够更好地利用这些资源吗？我正在使用WS2003。
如果没有使用实际的数据库进行调整，这仍然在开发中，有没有人有任何提高性能的技巧？ />
谢谢，
-
Dylan Parry
http://electricfreedom.org | http://webpageworkshop.co.uk
编程，n：类似于敲打一个人头部的消遣
靠墙，但奖励机会较少。
" Dylan Parry" < us **** @ dylanparry.com写信息
news：45 ********************* @ news.gradwell。 net ...
我在我的开发机器上使用了SQL Server 2005，而这个
机器并不像现场服务器那么强大，它有时似乎比我预期的要慢一点。所以我一直想知道是否有任何方式让我调整机器，以便SQL Server能够更好地利用这些资源吗？我正在使用WS2003。
如果没有使用实际的数据库进行调整，这仍然在开发中，有没有人有任何提高性能的技巧？ />
嗯，一般来说，你会发现调整数据库是最大的好处。
降价。
根据我的经验，您在服务器上找到的最大爆炸是磁盘
I / O.
确保您的日志来自
的单独物理磁盘（或一组磁盘）数据文件。
将RAID 1或10用于日志（通常用于数据）。 ）
更多内存可以提供帮助。
但是，
谢谢，
-
Dylan Parry
http://electricfreedom.org | http://webpageworkshop.co.uk
编程，n：一种类似于敲打一个人头部的消遣
靠墙，但获得奖励的机会较少。
-
Greg Moore
SQL Server DBA咨询
sql（at）greenms.com
Dylan
看一下quries的执行计划，以确保优化器是
可以使用索引。
你的数据库有多大？
服务器有多少内存？
Dylan Parry < us **** @ dylanparry.com写信息
news：45 ********************* @ news.gradwell。 net ...
我在我的开发机器上使用了SQL Server 2005，而这个
机器并不像现场服务器那么强大，它有时似乎比我预期的要慢一点。所以我一直想知道是否有任何方式让我调整机器，以便SQL Server能够更好地利用这些资源吗？我正在使用WS2003。
如果没有使用实际的数据库进行调整，这仍然在开发中，有没有人有任何提高性能的技巧？ />
谢谢，
-
Dylan Parry
http://electricfreedom.org | http://webpageworkshop.co.uk
编程，n：一种类似于敲打一个人头部的消遣
靠墙，但获得奖励的机会较少。
Greg D. Moore（Strider）写道：
在我的经验，你在服务器上找到的最大爆炸是磁盘
I / O.
谢谢，这可能是这台机器的一个因素。这是我的开发
机器，但它烦人地连接了一个网络驱动器
（物理上）被其他用户访问:(
< blockquote class =post_quotes>
确保您的日志位于单独的物理磁盘（或一组磁盘）上，而不是数据文件。
这是一个好主意。是否可以简单地*禁用* b $ b数据库的日志？原因是因为这是一个开发服务器我不是
远程打扰统计数据:)
-
Dylan Parry
http://electricfreedom.org | http://webpageworkshop.co.uk
编程，n：类似于敲打一个人头部的消遣
靠墙，但奖励机会较少。
Hi,
I used SQL Server 2005 on my development machine, and whilst this
machine isn''t as powerful as the live server, it does at times seem a
little slower than I would expect. So I''ve been wondering if there is
any way for me to tune the machine so that SQL Server is better able to
make use of the resources? I am using WS2003.
Short of tweaking with the actual database, which is still under
development, does anyone have any tips to increase peformance?
Thanks,
--
Dylan Parry
http://electricfreedom.org | http://webpageworkshop.co.uk
Programming, n: A pastime similar to banging one''s head
against a wall, but with fewer opportunities for reward.
"Dylan Parry" <us****@dylanparry.comwrote in message
news:45*********************@news.gradwell.net...Hi,
I used SQL Server 2005 on my development machine, and whilst this
machine isn''t as powerful as the live server, it does at times seem a
little slower than I would expect. So I''ve been wondering if there is
any way for me to tune the machine so that SQL Server is better able to
make use of the resources? I am using WS2003.
Short of tweaking with the actual database, which is still under
development, does anyone have any tips to increase peformance?
Well, generally you''ll find tweaking the database to be the biggest bang for
the buck.
In my experience, the biggest bang you''ll find on the server itself is disk
I/O.
Make sure your logs are on a separate physical disk (or set of disks) from
your data file.
Use RAID 1 or 10 for logs (and often for data.)
More memory can help.
However,Thanks,
--
Dylan Parry
http://electricfreedom.org | http://webpageworkshop.co.uk
Programming, n: A pastime similar to banging one''s head
against a wall, but with fewer opportunities for reward.
--
Greg Moore
SQL Server DBA Consulting
sql (at) greenms.com
Dylan
Take a look at execution plans of the quries to make sure that optimizer is
available to use indexes.
How big is your DB?
How much memory does the server have?
"Dylan Parry" <us****@dylanparry.comwrote in message
news:45*********************@news.gradwell.net...Hi,
I used SQL Server 2005 on my development machine, and whilst this
machine isn''t as powerful as the live server, it does at times seem a
little slower than I would expect. So I''ve been wondering if there is
any way for me to tune the machine so that SQL Server is better able to
make use of the resources? I am using WS2003.
Short of tweaking with the actual database, which is still under
development, does anyone have any tips to increase peformance?
Thanks,
--
Dylan Parry
http://electricfreedom.org | http://webpageworkshop.co.uk
Programming, n: A pastime similar to banging one''s head
against a wall, but with fewer opportunities for reward.
Greg D. Moore (Strider) wrote:
In my experience, the biggest bang you''ll find on the server itself is disk
I/O.Thanks, that probably is a factor on this machine. It''s my development
machine, but it annoyingly has a network drive attached to it
(physically) that gets accessed by other users :(
Make sure your logs are on a separate physical disk (or set of disks) from
your data file.That''s a good idea. Is it possible to simply *disable* the logs for a
database? The reason being that as this is a development server I''m not
remotely bothered about stats :)
--
Dylan Parry
http://electricfreedom.org | http://webpageworkshop.co.uk
Programming, n: A pastime similar to banging one''s head
against a wall, but with fewer opportunities for reward.
这篇关于提高绩效的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
