Will 150 concurrent users need an SQL Server with more than 2 GB RAM?

msuters

msuters

Active Member
Hi all,

Could you give me an idea of the memory requirements for the SQL Server of a new implementation of ERP8 on Windows 2000 with an SQL Server 2000 database. The concurrent users will be about 150 or less. We are trying to decide whether to go with SQL Server 2000 Standard or Enterprise. Standard supports a maximum of only 2 GB RAM, but Enterprise is 4 times the price. Also, if we need to expand, will we be better to add CPUs or RAM, in your experience?

I don't have experience of JDE in this scale, and your war stories will help.

Thanks,
Mark Suters
ERP8, W2K, SQL2000
---------------------------------------------------------------------------
Mark Suters - Senior Network and Applications Engineer
Stockland Group
M: 0417 318 245
E: [email protected]
---------------------------------------------------------------------------

#####################################################################################
Note:
This message is for the named person's use only. It may contain confidential,
proprietary or legally privileged information. No confidentiality or privilege
is waived or lost by any mistransmission. If you receive this message in error,
please immediately delete it and all copies of it from your system, destroy any
hard copies of it and notify the sender. You must not, directly or indirectly,
use, disclose, distribute, print, or copy any part of this message if you are not
the intended recipient. Stockland Trust Group and any of its subsidiaries each reserve
the right to monitor all e-mail communications through its networks.

Any views expressed in this message are those of the individual sender, except where
the message states otherwise and the sender is authorized to state them to be the
views of any such entity.

Thank You.
#####################################################################################
 
Hi Mark,
We run about 100 users at 6 sites with Sql 2000. We have dual processors and just went to 4 gig of memory from 2 gig for performance issues. Almost all users come into 3 citrix boxes.
It seems to run just fine with 4 gig of memory.
Any more questions feel free to contact me.
Regards,
Dave
 
Back
Top