Hi BaaNs,

- We have B40c4 / SQL7 / NT

- Application and Database all on one server


Situation:
=======
Currently the data volume is very high.

Now we are planning to add a new group company that will work on the same server.

Questions:
========

1) How do i have the NEW COY TABLES in another data base in
the same server
OR data base in another server

2) By keeping the another data base OR in another server will it
result in improved performance?

Any leads, ideas, cautions....


Highly appreciate your help, best wishes

VISH

Lets clarify a bit your questions:

- You want to add just another company or you want to add another instance/new database?
- If you want to add just a new company, do you really need another instance or can you just create a new tablespace for it?

- Having Baan running on one server and the database in another will improve the CPU usage, and if integrated into a cluster, provides some sort of high availability (you can switch packages), but will put an higher increase in the network bandwith.

- An increase in memory and/or increase of CPU's would not be better than having a second server?

I found this installation guide kicking around,
but I have never set up a three tier environment.

John

If you are asking about having the Baan group company in one instance and the remaining companies in a second instance, there are a number of issues you may encounter.

You have added a second single point of failure which may decrease overall reliability.

If one database fails and the second stays up, since there will be two database drivers (one for each instance), the transaction rollback will occur for one side of a transaction but not the second since Baan does not implement a two-phase commit. On top of the normal Baan issues of frequent commits, delayed locking, etc. this will introduce more complexity into your environment.

If you need to offload the CPU and are constrained, then add a DB server and put everything into the one instance but segregate the IO for the group company into a tablespace on different disks.

Running three-tier will cause some performance reduction, so if you have headroom in the existing server, expand that server and go on from there.

-- Jim

hi all

"Jroberts" thanks for ur doc. I am learning.

thanks Vic & James,

I think I will add to the scenario as follows.

1) Common network, LAN / WAN NOT dedicated for BaaN

2) We have 5 yrs of data 60GB, performance can not go any slower; we plan to hv one yr operational data under operational coy, but not wanting to remove the history but move it under a different archive coy. So I wanted this archive coy data in a different database.

3) We are adding a new live group coy with similar volume expected which I wanted a seperate database to handle.

If I can have these three data sectors(two group coy, one archive coy) in three different databases in one server or two servers .....? Is it possible ...How?

So that the performance is better (atleast I hope) Obviously a query on 5yrs data Vs. one yr data; maintenance backup takes less time on operational data;

tks for some lights

VISH

VISH,

A 60 GB database is not that large in the Baan space. If you are having severe general performance problems it may be related to the sizing of the servers, number of users or a problem with the DBMS maintenance procedures.

How many users do you have?

What kind of box are your running on (CPUs, memory, model, etc.)?

This will help us help you...

-- Jim

James,

here is the detail

Server:
COMPAQ ML530 Computer Archr: x86

System Processors :
Intel Dual Pentium III 800 Mhz 512Kb Cache Internal Memory

RAM :
1024MB (800 MB dedicated to SQL Server)

Harddisk:
Raid 5 System Total Disk Size : @92GB


OS: NT 4.0 with SP6

Swap space/paging/virtual memory setting:
1. 0 GB on C:,700 MB on D: ,700 MB on E:

tks

VISH