Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 4 of 4 total
Thread Server Hardware specs?
Fri, Jun 18 2010 2:32 AMPermanent Link

Bronson Alex

Hi all,

I am a newbie for C/S application, but I have been developing non-C/S application using DBISAM.
And now I'm about to develop my first C/S project for my office.
Could someone tell me what is the important aspect in choosing hardware specifications for PC server?
Is it the processor, RAM, or harddisk? What is the recommended specifications? What is recommended OS on server side?

There will be 3-5 concurrent users (under XP).
Database: 1 main table (10,000 rec) and 2 secondary tables (50,000 rec each), all tables have relationship to each other.

Thx in advance,
Bronson
Fri, Jun 18 2010 11:39 AMPermanent Link

Raul

Team Elevate Team Elevate

Bronson,

I'm sure there will be better advice but for 3-5 user C/S setup almost any hardware should run just fine (possibly even a desktop system you have laying around).

You will know your application DB usage pattern better but a recent CPU (few years old), 3-4GB of ram and reasonable drive (7200 rpm one) should be fine for what you described. In your case even Win XP as OS should handle this OK (as you'll be likely doing single digit number of TCP sessions to the server).

With the (C/S) server the goal is usually 24x7 operation so I would recommend going for system/components that are known to be stable (whether you buy it or make your own) and try to eliminate single points of failure:
- UPS for power
- 2 drives in RAID 1 (preferrably in hardware) so single driver failure does not take your server down

More is usually better (i5/i7 cpu, 10K SATA or even 15K SAS drives, more ram) but you are unlikely to use any of that power with 3-5 users and DB you have (i.e. most of the components will be idle most of the time).

Raul
Fri, Jun 18 2010 2:19 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Alex,

<< Could someone tell me what is the important aspect in choosing hardware
specifications for PC server? >>

What Raul said. Smiley Any desktop machine should work fine for such a task,
but make sure that you have a UPS and that you schedule a DBISAM backup to
run every night.  You can find out more on that here:

http://www.elevatesoft.com/forums?action=view&category=dbisam&id=dbisam_cs&page=1&msg=7425#7425

--
Tim Young
Elevate Software
www.elevatesoft.com
Mon, Jun 21 2010 1:24 AMPermanent Link

Bronson Alex

Raul and Tim,

Thx for your inputs. I will do as you told.

Regards,
Bronson
Image