I need to decided between Standard and Enterprise Edition (Cost is a
criteria - but its secondary to performance - <!--and I am not paying for
it myself-->)
The server spec under consideration: Dual Xeon, 1GB RAM, 36GB - RAID 1
(Dell PowerEdge 1850).
Application: Windows 2003 Std Server, ASP.NET, MS SQL Server 2000 based
data driven web application.
Approximately 25 simultaneous clients. Peak activity would probably be 50
transactions/activities per second (2 per second per client). I expect
the database size to grow up to 4GB in 1 year.
The application would use only basic OLAP features (if at all)...so
feature set wise I believe that standard edition is good enough.
What I am concerned about is when MS documentation says that Standard
Edition is for "organization that do not require the advanced scalability,
availability, performance, or analysis features of the SQL Server 2000
Enterprise Edition"
Is there a difference in performance between Std and Ent editions? In
terms of number of transactions per second that can be serviced?
What other criteria should I be aware of before deciding to go one way or
the other?
Any ideas?