Posted by David Portas on 10/20/05 08:00

> One reason for the horsepower is we are dealing with a bad old app that
> issues dynamic sql for 75% of its processing.

Buying hardware to solve a software issue is probably throwing your money
away, especially if you need to continue to scale in future. How about
investing some of that cash to fix the code first, then see what hardware
you need.

--
David Portas
SQL Server MVP
--

<csomberg@dwr.com> wrote in message
news:1129765159.626612.115640@z14g2000cwz.googlegroups.com...
> Howdy guys.
>
> I have the pleasure of assisting a friend with some changes to his
> system. One thing he needs is a new SQL setup that will scale.
>
> I was thinking of a quad exon box, 32 bit win2003 enterprise, 12 gig
> ram attached to a SAN via fiber with 15,000 rpm drives.
>
> If I need better perfromance, I will add servers on top of the san ...
>
> One reason for the horsepower is we are dealing with a bad old app that
> issues dynamic sql for 75% of its processing.
>
> Thoughts ?
>
> And ahead of time, I know sql server is choking itself at some point in
> this as well . . . .
>
> Thanks !!
>

[Back to original message]