We have a windows 2003 terminal server running 2X application load balancign that is hosting a client's application that is accessed by around 50 users.
Each user has there own database. The database is a file based database. The application is developed under Delphi so I think the database may be BDE based.
As you can imagine, there is probably quite a lot of disk i/o. Here are some of the perfmon settings.
Logged in users (average) 20 - 25 CPU Utilization (average) 80 - 100% Disk Queue Length (average) 1.6 % Disk time (average) 111 Page faults/sec (average) 1400
The application takes on average about a minute to load up.
As usual, the budget is tight. Is there basic windows performance tuning tips that people can recommend to improve things before we fork out on more RAM etc.
Server is a 2.8GHz Xeon with 3GB of RAM.