users@glassfish.java.net

Performance Tuning - Single request brings server to its knees

From: <glassfish_at_javadesktop.org>
Date: Tue, 09 Feb 2010 02:32:16 PST

First off, I'm in the deep end here. I fully acknowledge the noobness of this request but I've looked at a lot of tuning guides and have tried various settings in the admin console all to no avail so I would really appreciate some assistance.

[b]The problem:[/b]
We have an application deployed that runs great if you have one user on it problem is that we kinda want a few more then that. When the administrators do a bulk upload/delete which is fairly heavy in the number of database transactions it completely hangs for all users and badly. Its almost like there is only one thread and until it's finished nothing else can happen. I'm currently staring at two tabs (one admin/ one just to login) in firefox which have been spinning for the last 10 minutes!

[b]Our Setup[b]
Server:
3.2 ghz Intel XEON
2 processors
8GB RAM
Windows 64 bit

Glassfish: v2.1
DB: MSSQL
Other: Using Toplink and JSP

[b]Question[b]
How do I go about narrowing down what the problem is? Like I've said I have tried the tuning tips on several pages but they seem to have no effect. A lot of them refer to using the built in monitoring in the admin panel but I have to be honest I look at the results and have no idea how to work with the results.

Thanks for your time. Please let me know if there is anything else you need.
[Message sent by forum member 'scomley' (register_at_comley.org)]

http://forums.java.net/jive/thread.jspa?messageID=385608