Re: Where to 'spend the bucks' - Cost/Benefit advice wanted - Thanks...

Oops!
I forgot to mention that Guy Harrison is in the Quest Software Project. The Spotlight (Databases Instant Alertor) /SQLab Expert(Poor statements pin pointer and optimizing advisor) /Space Manager(Complete physical management solution) combination is a killer.
But that's already a bigger investment than just the book.

TurkBear <johng_at_mm.com> a écrit dans le message : 39f98b9a.76660461_at_news.news-ituk.to...
> Thanks Jerry and all that replied...I thought as much...Ram and Disk I/O
 seem to
> be the keys...
>
> Jerry Gitomer <jgitomer_at_erols.com> wrote:
>
> >
> >
> >>>>>>>>>>>>>>>>>>> Original Message <<<<<<<<<<<<<<<<<<
> >
> >On 10/26/00, 1:58:01 PM, johng_at_mm.com (TurkBear) wrote regarding Where to
> >'spend the bucks' - Cost/Benefit advice wanted:
> >
> >
> >> Hi all,
 

> >> Given Oracle's Power-Unit pricing, I need some real-world advice about
 the
> >> relative 'bang-for-buck' for
> >> CPU type/Speed/Number of
 

> >> Ram
 

> >> Disk Controller speed/IO in general
 

> >> We have a mixed environment, so if you could advise on both
 DSS/Warehouse
> >> instances, and TP instances ( an average of 200-300 concurrent
 sessions)
 , I
> >> would appreciate it..
 

> >> Mainly I am trying to determine how important CPU speed and number of
 CPUs is
> >> to performance relative to the other factors mentioned above...
> >
> >
> >> Thanks,
> >
> >
> >
> >> -----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
> >> http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
> >> -----== Over 80,000 Newsgroups - 16 Different Servers! =-----
> >
> > Based on my experience (YMMV) I would rank your factors as follows:
> >
> > 1. RAM
> > 2. More RAM
> > 3. Even more RAM
> > 4. Mirrored disk (if you are looking for bang for the buck
> > you are best off avoiding RAID 5 -- like the plague)
> > 5. Number of CPUs
> > 6. CPU speed
> >
> >
> >
>
>
>
> -----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
> http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
> -----== Over 80,000 Newsgroups - 16 Different Servers! =-----
Received on Tue Oct 31 2000 - 20:16:47 CST