Improving performance

[Greg D. Moore \(Strider\)]

Re: Improving performance

"Dylan Parry" <usenet@dylanpa rry.comwrote in message
news:45db3312$0 $756$bed64819@n ews.gradwell.ne t...

Greg D. Moore (Strider) wrote:
>

>If you can, upgrade your physical RAM. You won't regret it.

>
I wouldn't think twice before doing that if this were my home machine,
but it's at work, and I have a hard enough time getting new pencils
never mind RAM <g>

You know I'm reminded of the theory that you about painting a bikeshed. :-)

I feel your pain, but as lack of RAM is clearly causing a slowdown, it might
be easier to say, "Hey, spend the $100... increased productivity will pay it
back in a week.

>
--
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 http://www.greenms.com

[Erland Sommarskog]

Re: Improving performance

Greg D. Moore (Strider) (mooregr_delete th1s@greenms.co m) writes:

I'll add too that "memory is cheap". Most mobos these days will support 2
gig of memory (or more).

It's not that easy it sounds. First of all the motherboard needs to
support it. Second, motherboard and memory also need to be able to
play together. I had 2x512 in this machine, and bought a 1 GB board,
but with all of them in the machine, I got occasional blue screens. 1.5 GB
works fine, though.

--
Erland Sommarskog, SQL Server MVP, esquel@sommarsk og.se

Books Online for SQL Server 2005 at

http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx

Books Online for SQL Server 2000 at

http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx