|
|
Posted by mike on 12/07/06 23:47
I know i must work on queries and other things
was just wondering what a good configuration is
at the server level.....
thanks for the information
mike
"Erland Sommarskog" <esquel@sommarskog.se> wrote in message
news:Xns9892EE00675BEYazorman@127.0.0.1...
> 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
Navigation:
[Reply to this message]
|