Supporting 1000 user sessions on Solaris, Linux or Windows

Hi all

We have an application that is accessed by 150 users concurrently (every user uses 6 connections to the database = 900 sessions). This application is now running on Sun Solaris 2.7 on a E3500 server with 2 GB of RAM in MTS mode.  

SGA:

NAME                          MB
-------------------- -----------
Fixed Size                   .07
Variable Size             330.95
Database Buffers          703.13
Redo Buffers                 .17
                     -----------
sum                     1,034.32

init.ora
db_block_buffers = 90000
shared_pool_size = 192M
large_pool_size = 64M
java_pool_size = 64M
mts_servers = 10
mts_max_servers = 10

Within this setup the application runs acceptable but certainly not optimal.
For the next few months the application will be enhenced by two heavy features:
* scanned invoices will be included within the transactions

• materialized views (in synchronous mode) will be used everywhere and the users who access this application will rise from 150 to 200 users (= 1200 concurrent db sessions)

We are now planning a new db server that should carry that load for the next four years. The options are:
* The new Sun Fire V880 Server with 4 CPUs and 8GB RAM

• an IBM Netfinity with 4 Xeon and 4 GB RAM
  • with SuSE Linux
  • with Windows 2000

Now my question:
Is it feasable to run this load on Linux or Windows NT ?

With best regards

Martin Pammer
VRZ Informatik
6850 Dornbirn
Austria
m p a m m e r <at> v r z . n e t Received on Thu Jan 24 2002 - 05:26:05 CST