I am using tomcat 4.12,jdk 1.4 and SQL server 2000 as back end.
while accessing report ticket module in our application continouosly, module details screen takes time to load. at that time while accessing other modules in the another browser, it is also not loaded.

That report ticket module is interrelated with the all other modules.

After that i have restarted the tomcat and accessed report ticket module continouosly. after few hours same problem occured.

I have checked sql profiler to check the queries which is taking longer time.
and also analyzed the queries which takes longer time.

WHy the problem occured while accessing the particular module...