Posted by Greg D. Moore \(Strider\) on 02/19/07 15:12

"Dylan Parry" <usenet@dylanparry.com> wrote in message
news:45d9b87d$0$758$bed64819@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

[Back to original message]