Ask the Expert

Windows or open source for an ERP platform?

We are considering an ERP platform and have not yet closed in on our ERP vendor choice. We are however very, very close. Our enterprise level database of choice is Oracle regardless of our other choices. Can you tell me what are the primary considerations in terms of per user bottlenecks associated with delivering an ERP solution with an Oracle database on an open source versus Windows 2003 platform? We will most likely use 9i, but we haven't completely ruled out 10g as the database. We understand there to be a constraint of say approximately 500 concurrent users in an Oracle/Oracle on Windows environment. Is this driven by a per user memory requirement in the portal, since the database advertises huge SGA buffer limits up to 64 gigabytes and up to 10,000 users utilizing the Oracle Shared Server Process? Please help us with the trade-offs to consider.

    Requires Free Membership to View

There used to be a general rule of thumb that Oracle on Windows would not support much more than 500 concurrent users. The reason for this rule of thumb was due to the fact that Oracle on Windows did not handle Shared Server connections very well. You will be happy to know that Oracle 9i and Oracle 10g handle Shared Server connections very well. This rule of thumb is not applicable any more.

In today's Oracle environments, the decision to go with Windows or an open source operating like Linux depends more on your company's expertise. If you have Windows administrators but no Linux administrators, then it only makes sense to run Windows. If you have Unix or Linux administrators, but no Windows administrators, then choose Linux.

There are a few other reasons to choose Linux over Windows. Linux servers that do not run a GUI environment typically outperform Windows isntalled on the same hardware. The Windows server has to spend additional overhead supporting the GUI environment, even if no one is directly connected to the operating system. Oracle Corp is also coming out with many tools such as Linux clustering software, which can help you as well.

This was first published in November 2004

There are Comments. Add yours.

 
TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: