You are here: Re: Performance Difference between SQL Server 2005 Standard Edition and Enterprise Edition « MsSQL Server « IT news, forums, messages
Re: Performance Difference between SQL Server 2005 Standard Edition and Enterprise Edition

Posted by Gert-Jan Strik on 12/20/06 17:57

nitin.goel@daffodildb.com wrote:
>
> 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.
> [snip]

I am not sure you are aware of this, but the EE is approximately 4 times
as expensive as SE (when using CPU-based licensing). There is no way you
can make a business case that justifies spending an additional $15,000
on EE for performance reasons. If you were to spend another x dollars on
performance it would definitely be in the hardware, in whatever area is
limiting perfomance (in your case most likely in the I/O area). But if
you don't have to spend the money now, then you can postpone such
decision and see how it runs with the current hardware.

As for your maintenance window: it should be more than sufficient to
handle any problems with a database of just 20 GB, so from that point of
view you don't need EE either.

Gert-Jan

 

Navigation:

[Reply to this message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация