What version of SQL Server to buy??

[btt423]

A little background...
I work for a government agency and we have finally gotten approval to use SQL server in production. Now, I am trying to decide which version to buy (standard or enterprise). The way we are setup, SQL Server will only be used for small to medium-sized web applications. Any large or enterprise applications will use Oracle or DB2 due to agency policies.

It looks to me like standard will work fine for us since any analytical or heavy duty processing will not be done on these applications. However, I won't to be sure we don't buy the wrong version and be left hanging sometime in the future.

Any advice would be appreciated.

Thanks!

 

[tlbroadbent]

You should review carefully the differences in versions.

We have chosen Standard edition. We run 8 production servers and 3 test servers. We have a mix of Web (JAVA, ASP, VBScript, JavaScript, etc.), VB, and Access apps developed in-house. We also run several 3rd party apps.

There are over 2000 users. Some apps are used by all users. Some apps are used by a few. We can have as many as 200 concurrent users on some servers. Databases range from about 1MB to over 5GB in size.

We are running SQL 7 on some servers and SQL 2000 on the others. We are able to tune the servers and apps so that response is excellent. Thus far, all of our needs are met by the standard edition. Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.

 

[dbmsguy]

Where I was, one of the big issues with std vs. enterprise was that std edition can only use 2Gb of memory, whereas enterprise edition can go above that. Paul

http://www.dbmsguy.com