Posted by Erland Sommarskog on 12/07/06 22:24

mike (vettes_n_jets@yahoo.com) writes:
> Im New with a company and the sql server is
> maxing out the cpu's
> We have 3 web servers load balanced....
> large volume of data
>
> the current Properties
> Computer:
> 4 amd 2.88 processors
> 4 g Mememory
>
> Recomendations of good sql setup
> memory, cpu etc

While you can achieve some performance benefits by tuing the hardware
and its configuration, the major impact is usually in looking at queries
and how they are submitted.

For instance, a web app that submits all queries as fixed string with
input parameters interpolated, will take a far bigger toll on the server
in compilation and cache-lookup time than an app that uses parameterised
queries. Even more decisive is of course whether quereis are supported
by suitable indexes. And finally, good defragmentation rouines are really
helpful.

--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

[Back to original message]