[WBEL-users] RE: Whitebox-users Digest, Vol 6, Issue 31

kirby kirby at igalaxy.net
Sun Jun 26 11:53:21 CDT 2005


Erick,

At first glance that system is undersized.  This depends heavily on your
application for a very 'light' application this might be fine.

CPU seems slightly low, but might be okay.
RAM is low.  Putting 4GB in there would likely seem you some improvement as
more data can be loaded in RAM rather than disk
Disk is likely fine if most of what you are doing is read intensive.

As a baseline I recently set-up a 110 user (maybe 20 active at a time)
OLTP/Data Warehouse Hybrid with 12 GB RAM running on Windows 2003.  The
entire database was approx 70GB in size (30GB was a tempfile because of some
poor SQL code) CPU was 2 3.2GHz P4's.  It was a client/server based
architecture.

1) When you say 50 users .. Is that 50 users on-line concurrently?  If not
... How many concurrent users?
2) How large is the database? A 10GB database is much easier to run than a
100GB one or 1TB.
3) What kind of processing are they doing?  Simple OLTP or heavy reporting?

Good luck,
Steve




More information about the Whitebox-users mailing list