Posted by Erland Sommarskog on 12/20/06 22:25

(nitin.goel@daffodildb.com) writes:
> Here is the H/W and database configuration in this case.
>
> 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.

Does this mean that there are more CPUs in the box, but there are
other applications that gets to use those? Or is there only one CPU
in the box, and SQL Server is the only app on the machine?

The main reason I ask this, is that if there other apps on the machine,
this makes it even more difficult to assess your questions.

> FYI, we have searched MS SQL Server books online + seen the differences
> of SE and EE given by MS + asked our local vendor but he knows nothing.
> And the queries run by us are select queries with joins on around 5 -1
> 0 tables. So the picture is still murky and Microsoft is not answering.

And since you never post any of the queries, and nor the query plans,
you are not giving us any chances to straighten things out.

But I like to agree with what Gert-Jan said. If you have extrememe
performance requirement, you may want to cough up the extra money for
Enterprise to get whatever small fraction you can win. But if you
had those requirements, you would not let it suffice with a single
CPU box.

So go for Standard. Keep in mind that if your business expands and
you will want Enterprise one day, you can always upgrade at that point.


--
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]