Re: Recommended Wintel Hardware

> If you were building the best Oracle server you could, single box,
> must run Intel and Windows 2000, what hardware would you recommend?
> Hard drive space is not a consideration because we will be using a
> Network Appliance Filer. What brand of server, how many processors,
> how much ram, xeon, p4, hyperthreading, etc?

I wouldn't use Windows, I'd use Unix. But oh well....

> 300 users, 100 gig database, horribly inefficient transaction logging.
> I need brute power to overcome programming shortcomings!

Throwing more hardware at the problem may not solve your shortcomings. It is a misbelief that newer, faster, better hardware with more resources and capacity will solve all of your problems. In fact, you may introduce more problems. There have been many instances where applications have performed worse after a CPU upgrade because now more processes are waiting on I/O. And if performance is an issue, then I'd stay away from NetApp's too.  

> Currently running a 4-way Dell 6450 with 4 gig of ram, and its getting
> its arse kicked.

What do you mean by getting it's "arse kicked". More specifically, what part of the server is it that can't handle the load? Are you experiencing CPU contention, memory contention, I/O contention? To tune performance problems, one needs to narrow it down to the bottleneck and address that specific bottleneck. I just don't double all of my SGA settings hoping that more memory allocation will fix my database problems. Similarly for the server.

Cheers,
Brian

-- 
===================================================================

Brian Peasland
oracle_dba_at_remove_spam.peasland.com

Remove the "remove_spam." from the email address to email me.


"I can give it to you cheap, quick, and good. Now pick two out of
 the three"