tomcat problem- very urgent

i am using tomcat 4.12 and sql server 2000...

while multiple users accessing our application, each page takes time to load...

i have checked task manager. before loading the page, the tomcat usage is 70 MB, once the page is loaded the usage is keep on increasing...

after unloading the page, tomcat usage is not decreased..

what should i do for that ? how to check the sql server open cursor?

Well Tomcat runs Java, and Java is a bit of a memory hog. So there is not a lot you can do aside from buying more RAM :(

I suppose you could set the java process running tomcat, to use no more than say 512 MB RAM, that way you force Java to garbage collect when it reaches this limit. I can't recommed forcing tomcat to run with less that 512 MB RAM.