I am going to be converting my existing customers to client/server from a
local access system (LAN-based). The new server data will be access over a
LAN and by the internet.

Is there a document describing server machine requirements available
anywhere so I don't miss any points when I explain what is necessary for my
customers' network support personnel?

Things like:
TCP/IP ports need to be open, forwarded to server machine
Memory and other system requirements

Thanks,

Johnnie Norsworthy

Johnnie,

<< Is there a document describing server machine requirements available
anywhere so I don't miss any points when I explain what is necessary for my
customers' network support personnel? >>

There really aren't any requirements due to the fact that the database
server will run in practically any configuration.  It may not be optimal,
but it will run.

<<  Things like:
TCP/IP ports need to be open, forwarded to server machine
Memory and other system requirements >>

Well, yes, the obvious things that need to be taken into account is that
TCP/IP support must be on the machine and in working order, and the two
ports used by the DBISAM database server must be open if you want to access
both the standard data port (12005) and the admin port (12006) from outside
of the server machine.  As for memory, 512 megs or more is usually
sufficient, but it really depends upon the number of expected concurrent
sessions on the database server, which you didn't mention.

--
Tim Young
Elevate Software
www.elevatesoft.com

"Tim Young [Elevate Software]" <timyoung@elevatesoft.com> wrote in message
news:F4352102-C534-4E86-94A8-06FBB253E9E1@news.elevatesoft.com...
> Johnnie,
>
> << Is there a document describing server machine requirements available
> anywhere so I don't miss any points when I explain what is necessary for
> my customers' network support personnel? >>
>
> There really aren't any requirements due to the fact that the database
> server will run in practically any configuration.  It may not be optimal,
> but it will run.

That's the kind of thing I mean. I know the Delphi IDE will run in a low
amount of memory but it would be unbearable. I was just looking for a
general idea considering the number of concurrent users, maybe increments
like 1-5, 6-25, 26-50, 51-100. Though I have installations of almost 200
machines, I don't think there would ever be more than 50 concurrent users of
my server.

>
> <<  Things like:
> TCP/IP ports need to be open, forwarded to server machine
> Memory and other system requirements >>
>
> Well, yes, the obvious things that need to be taken into account is that
> TCP/IP support must be on the machine and in working order, and the two
> ports used by the DBISAM database server must be open if you want to
> access both the standard data port (12005) and the admin port (12006) from
> outside of the server machine.  As for memory, 512 megs or more is usually
> sufficient, but it really depends upon the number of expected concurrent
> sessions on the database server, which you didn't mention.

I am going to organize my document into three parts:

MACHINE REQUIREMENTS:
 OS, Memory, CPU speed, UPS system

NETWORK REQUIREMENTS:
 TCP/IP, firewall/router setup

PERFORMANCE:
 What can be done to improve LAN performance and remote internet
performance such as increasing upload bandwidth
 How using the machine as a workstation might degrade performance or cause
problems if other applications crash.

If I get the document looking good enough, I'll post it to the binaries
group for others in the DBISAM community to use as well.

-Johnnie

Tim, thanks so much for the great support here all the time.

Johnnie Norsworthy wrote:
> I am going to be converting my existing customers to client/server
> from a local access system (LAN-based). The new server data will be
> access over a LAN and by the internet.
>
> Is there a document describing server machine requirements available
> anywhere so I don't miss any points when I explain what is necessary
> for my customers' network support personnel?
>
> Things like:
> TCP/IP ports need to be open, forwarded to server machine
> Memory and other system requirements

I'd say, to be safe:

- CPU: Pentium D or any other dualcore

- RAM: 2 GB

- HD: 2 fast ones, Seagate Spinpoint JJ or WD Raptor, mirrored

- Gigabit ethernet

- Windows Server, because Prof. has a limitation of 10 concurrent TCP/IP
connections.

That should be more than enough for most installations, and it's standard
stuff. If you only have 5 users and there is not much to do for the server,
you can live with a cheap Sempron 3000+, 512 MB machine with Win2k Prof.

Ralf

Johnnie,

<< That's the kind of thing I mean. I know the Delphi IDE will run in a low
amount of memory but it would be unbearable. I was just looking for a
general idea considering the number of concurrent users, maybe increments
like 1-5, 6-25, 26-50, 51-100. Though I have installations of almost 200
machines, I don't think there would ever be more than 50 concurrent users of
my server. >>

The basic equation is to take the amount of memory used per table, multiply
it by the projected number of open tables per session, and finally multiply
that by the concurrent number of sessions expected on the database server.
The amount of memory per table is controlled by the TDBISAMEngine properties
below:

http://www.elevatesoft.com/dbisam4d5_tdbisamengine_maxtabledatabuffersize.htm
http://www.elevatesoft.com/dbisam4d5_tdbisamengine_maxtableindexbuffersize.htm
http://www.elevatesoft.com/dbisam4d5_tdbisamengine_maxtableblobbuffersize.htm

That will give you a ballpark estimate on memory needs.

<< If I get the document looking good enough, I'll post it to the binaries
group for others in the DBISAM community to use as well. >>

Fantastic, thanks very much.

<< Tim, thanks so much for the great support here all the time. >>

No problem.  I wish I could be more "verbose" lately, but I'm trying to
balance a lot right now and I have to be brief with my responses.

--
Tim Young
Elevate Software
www.elevatesoft.com

> - Windows Server, because Prof. has a limitation of 10 concurrent TCP/IP
> connections.

Where is this limitation?  I thought this had more to do with the number of
connections to the machine for share acces, not a DBISAM server.  I have
many more users than 10 accessing a XP Professional machine.

Bill

From my research (using Google and spending hours reading), it
*appears* to me that there is no limit of 10 connections enforced for
non-MS software (e.g. DBISAM database server). However, you *may* be
violating the MS license agreement for WinXP Pro/Home or Win2000Pro.

Jason

B Miller wrote:
>>- Windows Server, because Prof. has a limitation of 10 concurrent TCP/IP
>>connections.
>
>
> Where is this limitation?  I thought this had more to do with the number of
> connections to the machine for share acces, not a DBISAM server.  I have
> many more users than 10 accessing a XP Professional machine.
>
> Bill
>
>

Bill,

<< Where is this limitation?  I thought this had more to do with the number
of connections to the machine for share acces, not a DBISAM server.  I have
many more users than 10 accessing a XP Professional machine. >>

You are correct.  The 10-user limitation has to do with other machines
accessing shares on one machine, not TCP/IP connections via Winsock.  I
think the socket limit for Winsock is 64K (or possibly even higher now).

--
Tim Young
Elevate Software
www.elevatesoft.com