Re: CPU and RAm requirement and Custom Mods
Hello Nick,
I did some sizing myself on a AIX/Oracle/Citrix platform a couple of years ago here. Here's some of my experience that I want to share with you for your decision making process...
We're running 40 locations with a maximum of 250 concurrent users with approx. 10.000 business transactions per day. I configured, only for PRD, 2 AIX servers (S85): One Oracle server, 12 CPU's, one JDE server 8 CPU's, both 24GB memory, all data on a clustered NetApp NAS system and a Citrix farm of 10 Dell 2850's.
Any hardware vendor (including IBM) will tell you that this is WAY oversized given the amount of concurrent users and transaction figures (so did I), but in the end... it doesn't perform. Sometimes minutes response times for end-users!.
The culprit appears to be in the custom mods... At the beginning of our implementation, we first started off putting approximately 20 man-years of JDE custom development in our system before rolling out the first site. The first site went live, 25 users, no data yet, performed like a rocket, so far so good.
As more and more sites went live, the data grows, the amount of users grows, the technical efficiency of your applications becomes more and more relevant.
And... if you have 15 'functional' developers clicking away for 2 years without worrying about performance, the system that results can in no way be compared to 'JDE out-of-the-box'. Believe me, we had every Oracle DB-specialist, AIX specialist, CNC specialist money can buy here, but they all came to the same conclusion: "The problem is in the application, not in the HW, DB, OS, network"
So my advice is: consider the amount of customization that you expect in the sizing of your hardware. Furthermore, make sure that the development process contains technical reviews of the generated code/queries. If not, you will definately end up having an undersized system with corresponding performance problems.
Quote from Oracle-JDE specialist: "If you develop in JDE without worrying about the code that results, it most likely will have a significant negative effect on the performance"
Hope this helps,
Lambert