Hi All.  

I've been working on updating a series of Delphi 5 apps created using FlashFiler to EDBServer. Down the road Delphi 5 will be updated to the current Delphi version.   It's coming along, but there's still more work ahead.  My work environment is a Windows XP Virtual Box on a Windows 10 host.

We'll be updating our current Windows Server 2012 to 2016, and we need to plan the new Server configuration.  I'd  I'd like to get a sense of optimum memory for the new Server.  My inclination is to have the database and apps reside in a Server 2016 VM as opposed to running directly on the host.  It will most likely be VMWare.

The database as it is now is occupying about 3G of disk space.  
There are about 45 regular users.  About a third will be heavy users.  The rest will use the system just for tracking time for jobs and payroll.   

I realize there can be many variables in determining the optimum memory needed.  A rough estimate is what I'm looking for.  Any help will be appreciated.

Thanks,
Judd

We did a rough estimate recently and came out with approximately 70 MB per user. With the way our application is configured, a single user may have a number of sessions to the server. Given it's a system with its roots back in the late 90's with the BDE and Paradox, there are a lot of TEDBTable objects open on each connection, rather than TEDBQuery-based stuff.

As ever, your mileage may vary.

Hi jkr,

I have just looked at TaskMan on our Server. 16 connected users are showing EDB Server using slightly less than 1gB of memory, which equates to about 60mB per user.

I only use TEDBQuery for connections, not TEDBTables, but allow all users to have fairly sizeable data-sets open and keep them open, there is relatively little optimization of user data access, except that I spend a lot of time crafting SQL to try to make it run faster.

I am sure I could make it work far more efficiently. I have never really needed to optimize memory use, as the server has plenty.

Thanks to both of you.  It gives me a good starting point.  Exactly what I was looking for