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?