October 30, 2002 at 3:19 am
There is a huge price difference between Standard and Enterprise editions of SQL Server2000.
It is a bit of a how long is a piece of string questions but does anyone have any guidelines for the maximum number of users for the Standard Edition?
I have been working on the principle of between 10-20 users per cpu.
I have a web content management system that makes heavy use of SQL Server during the authoring and publishing processes, especially as it uses cursors a lot.
Web content is stored within the database and the publishing process assembles a page and writes it as a flat file.
None of the advanced features of the Enterprise Edition are needed but the multi-processor support and the capacity for additional memory may be useful.
October 30, 2002 at 4:19 am
The memory and CPU support do it for me. Gets even more expensive since you need WIN2k AS as well. I recommend always going with Enterprise to have the room for growth.
Andy
October 30, 2002 at 8:42 am
Unless your 10 to 20 users are really beating the DB to death with OLAP type stuff that seems way to low.
We have a 15gig DB, with 300ish users, a very poorly designed app (purchased) on an older dual with 2 gig of ram, and they pound this thing. We don't see any real problems.
The memory and CPU count can become an issue, although you can now begin looking at HTT CPUs which sort of double the processor capabilites but license as singles. At least until MS decides they need a little more revenue.
KlK, MCSE
KlK
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply