Posted by lucm on 12/20/06 14:25

> System: - HP Proliant ML 370 G4 Server ( Intel Xeon 3.2 GH on Intel
> 7520 Chipset; Dual CPU capable )
> RAM: - 4 GB DDR2 ECC
> HDD: - 2 * 73 GB SCSI ( 15000 RPM ) RAID 0
> DB size: - 20 GB
> Downtime: - 2 hours a day i.e. morning 5 to 7 AM.
>
> Parallel queries: Parallel Query processing runs only on multiple
> processors. In our case only one processor is available to SQL Server.
>
> RAM: it is an OS issue and not of SQL Server. There is no RAM support
> specification in SQL Server (EE / SE). By the way, OS used by us is Win
> 2003 Server EE.
>

First of all, RAID-0 is a no-go. If this is a production server you
need at least a mirror (RAID-1).

Now, do you *need* EE or not? Without a load average it is difficult to
say. Since you purchased a server with a single CPU and a small amount
of RAM, you probably don't have too many concurrent users.

One of my customers has up to 100 concurrent users, he has a hardware
weaker than yours, a bigger database, and he is very happy with SE.
They make quite an extensive use of the server, and they can afford the
downtime when they restore lost data or rebuild indexes.

Regards,
lucm

[Back to original message]