I'm trying to find out how Big a Baan installation W2K/SQL2000 can handle. I can't seem to find any decent case studies for larger installations (say, 200+ concurrent users).

Is anyone using Windows/SQL with Baan with 200+ concurrent users? If so, what is the system spec, how is reliability and what issues are there? Or is it only for SMEs?

Thanks

Aeolian

I know of a customer who has 300 concurrent users and a Baan database of size almost a terabyte recently went live on level2. (They found huge gains in performance in many areas and almost equal or slightly greater performance in the rest. Database size has reduced by almost 40% after moving from level1 to level2.)

They have their production system consisting of 4 application servers (with 4 CPU, 4GB RAM, 40 GB disk each) and a DB server (with 8 CPU,8GB RAM, 1TB disk space).

After moving to level2 for BaanERP5.0c, their database size came down from 700+ GB to around 390 GB. Their db growth rate too got reduced by 50%.

Regards,

Hi aeolian


Did you get anyother responses to your question as to scalability ?

Were you interested in Baan IV or Baan 5 ?

I ask as we are trying to find user experience in the same area as you but with 250 users on IVc4 or Baan 5 ( we may migrate but if so it will be to Baan 6 )

Also we wish to compare Informix version ?? to SQL

So any information would be useful

in q2/2003 there will be an benchmark
with ~7000 users / w2k / sqlserver
on fsc-platform

we will see ...

In sites >200 users the vast majority are on UNIX. I know of the SQL account refered to earlier and it is definitely the exception. I have three accounts including that one which are >200 on Win 2000. But two of them are on Oracle...

Baan 5 -- much better choice due to the TODAY availability of L2 drivers.

It will work -- but UNIX will work "more better" as my HP-UX internals instructor used to say...

-- Jim

Thanks Jim

I am sure that Unix is "much more better" but a "policy" decision has been made to move to Windows.

We are homing in on IDS Workgroup Edition ( with the 4 processor limitation) using an application and DB server

As we run 4 instances SQL is a nogo

The ship is launched and is being fitted out , we are selecting the fittings and the crew.

From CPU point of view: As far as my knowldge goes: On NT/W2K adding more CPU scales less compared to UNIX. Especially above the 4 CPU's.

From a database point of view there are differences in the high end and for me this is above the 500 users so I assume this does not count for you.

Scalability depends on more than only CPU and database scalability. Good scalability also requires a good scalable product. In general Baan scales very well but when adding more users, it becomes a problem when users start to do the same work on the same tables (locking). At this point it depends on the sessions you are using if your configuration can perform/scale well.

But in general I don't see any real issues when having less than 300 users on a W2K/MSQL box for scaling.

Kind regards,
Dick

Many Thanks for advice Dick

As stated we have 4 CPU on both Application and DB servers

We will be using IDS Workgroup Edition FC7.31 UD5

We will now have 5/6 instances

We shall know results by start of Q4/03

That changes things -- are you asking about 5-6 seperate instances on different machines supporting this many users?

Hi James

Yes the data will be held on the one DB server but will be allocated to some 9 Baan coys within 5/6 instances