Posted by lucm on 12/21/06 19:34

> 1. Sorry I have made a mistake, our DB size is 50 GB not 20 GB (typing
> mistake).
> 2. There are around 100 concurrent users accessing this db from 30
> locations.
> 3. There is only one CPU in the box and only SQL Server runs on it.
> 4. Regarding I/O performance, what more can be done in I/O area (
> that's a very novice Q but I have never worked in this field ).
> BTW I know price of both SE and EE but we will spend only if we see any
> gain EE. And we are also ready to spend on I/O if it is good for us.

Basic rules for the I/O on a database server: a RAID-10 array using as
many disks as possible (even number) is the best scenario for the
databases, while a 2-disk RAID-1 array is great for transaction logs.

If you use temporary tables, having a distinct 2-disk RAID-1 array for
tempbd is excellent (even better: a 4-disk RAID-10). As for the disks
themselves, the smaller and faster is the better; your 73 GB 15k are
excellent.

If you can afford it, having a RAID controller the databases (RAID-10)
and another one for the transaction logs and tempdb (RAID-1 or RAID-10)
is optimal.

Also don't be shy to add some RAM, as much as you can.

Regards,
lucm

[Back to original message]