We are facing this issue since past 2 days and have not been able to resolve. Any help on this will be greatly appreciated.
Our Environment is
Intel P4 1.60 Gz, 512MB RAM, 40GB hd
Software: jBoss 3.2.1, JSP/Servlet, Hibernate OR Layer, SQL Server 2000
OS is W2K 2000 sp 3/ J2SDK 1.4.2_03
(database server is different m/c).
We have also tried this on a high end production server which has multi processors and 4GB of RAM
The application carry out batch processing for records (some calculation transactions) on a monthly basis. Our test runs on P4 / 512MB etc with the above s/w gives us a decent rate of processing (about 5 recs/mnt) however, on the production server and one particular test server this is slowed down (about 3 mnts for 1 record to 10 mnts / record).
We eliminated SQL Server 2000 side after going thru optimization and monitoring and have finally zeroed in on J2SDK / jBoss (or worst case the hardware).
Has anyone faced this kind of issue ? What is it that we could do more ?
Thanks in advance