Posted by csomberg on 10/20/05 02:39

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 !!

• Next in forum: Re: Using "SELECT * " is a bad practice even when using a VIEW instead of a table?
• Prev in forum: Re: Database Access over Internet
• Thread view: I wish upon a new server ....

[Reply to this message]