Any thoughts on the best setup performance wise.
Would it be better to have LN6 running on a separate application and database server or is it faster running on a combined application/database server. At present we are running on a combined server but as we are going to migrate to new hardware we are wondering which is the best setup.
In case of two separate servers the link between the servers would be of course be made with fibercables.

Our current environment is single logistic multi finance. and our database is currently approx. 150 GB

TIA

Kansel

There are tradeoffs. Having the application as well as the database may definitely give better performance, but you run the risk of losing everything in Baan (application and data) if something goes wrong with your server. Besides, since your database size is large, it would be a good idea to use a separate server for the database. It will also help your Baan administrator and database administrator to work on their own in case of problems. However separating the servers would complicate things a bit, setup wise. In the end, you call the shots.

Kansel,

having all one one box will perform the best if CPU's are of same speed and you are not CPU bound. This as you eliminate the network. The network can be fast, but it is always slower than no network.

Deciding to use 2-tier vs 3-tier is something that you don't deside in 5 minutes. There are a dozen of reasons to think about when you discuss this topic. You can read a lot on this topic on this board.

Happy reading,
Dick

Thanks for your replies.
Our current setup is 1 server with 8GB ram 4 Dual Xeon processors and a SAN box for storage. This server is running both the application and the Database and as mentioned earlier the database is currently approx. 150 GB and rapidly growing. The numbers of concurrent users are 100 give or take a little.
My concern right now is that I seem to be able to get better performance on a much smaller server running on local disks. Are we perhaps outgrowing the MS platform and need to move to a different platform?

Regards,
Kansel

Measure is my first idea. To elaborate this a bit more:
- measure how much your CPU utilization is. If it is less than 95% on peak level 3-tier will not benefit you.
- measure if your database is preforming optimal. Even if you have fast disks, reading from disks is slower than from memory
- measure if your baan environment is not having issues.

100 users on a 4 way dual xeon box is not bad in general. 150Gb is nothing for a well tuned database. But the application can maybe have some bad parts that give you the idea that you outgrow your server.

let me know if this is sufficient for you or that you need some more help. At least this link (http://www.baanboard.com/baanboard/showthread.php?t=7665) can help you I assume.

Kind regards,
Dick

Hi Dikkie,

Thanks for your insights. I will looked at the link and you were right that was interesting reading.

Kind Regards,
Kansel