Performance

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: Shabam (chalupa_at_yomama-nospam.com)
Date: 03/14/05 

Date: Sun, 13 Mar 2005 21:57:15 -0800

I have an application that allows for searches, but it appears when I stress
test it with 50+ users the CPU utilization on the MS SQL server machine is
hitting 100%. The machine is on RAID SCSI, running on 4GB of memory and
dual AMD Opteron cpu's. I can get a more powerful machine, but not sure if
that is the solution here.

What are some methods to scale this thing out? Replicate the database and
spread out the searches to multiple identical databases?