Also, if possible, place the transaction log on a separate, dedicated hard disk. This will increase performance in writing to the log, since the log data are written serially.
>Jun,
>
>With servers, the "golden rule" is buy as much as you can afford.
>
>The following components are the most important, in descending order:
>
>Storage subsystem - SCSI Raid Array. You will want separate arrays for the Operating System and the SQL Data, preferably connected to separate RAID adapters.
>RAM - as much as the motherboard can hold, minimum of 1GB.
>Network card - if you have a gigabit switch, try for a gigabit card.
>CPU - go for L2 cache over raw speed if you have to.
>
>>Hi,
>>
>>We are going to purchase SQL Server 2000 with one CPU license.
>>I need some advice on what the server box should be, we are going to purchase a new one.
>>
>>Thanks in advance!
>>
>>Jun
The whole problem with the world is that fools and fanatics are always so certain of themselves, but wiser people so full of doubts. - Bertrand Russell