Page loading Problem

Hi,

I am using tomcat 4.12 and jdk 1.4.0.. sql server 2000 is the back end.

when we accessing our application contionusly for more than 4 days, each page takes time to load..

I was looked out both java and sql server usage. sometimes both usage were high. sometime it was decreased...

is this because of tomcat problem or in sql server problem?

Thanks

Dev team

[403 byte] By [memory_leak_problem_efirsthelpa] at [2007-10-2 8:54:44]

«« Displaying the Selected Data in the Next Page Upon Selection?
»» setRequestEntity

# 1

Are you sure that the Servers are running off some powerfl machines (Hardware?)Are you sure that the Connections to SQL Srever are being properly created and closed form JDBC calls?

pazhanikanthana at 2007-7-16 22:58:42 >

top of Java-index,Developer Tools,Debugging and Profiling Tool APIs...

# 2

Hi,

Actually our system have 1 GB RAM ..

We are creating and maintaining connection pool manually. means that we have written a file for connection pool management.

We have closed the connection and statement in the finally block in each file.

how can i check the sql server connection and jdbc calls are properly closed and also which table taking more number of resources?.

Thanks

Devteam

memory_leak_problem_efirsthe at 2007-7-16 22:58:42 >

# 3

1. Check the queries using "Execution plan" for the frequently used programs / Queries2. Using "select @@spid" in the query analyzer trace how many connections were used in each module3. Can you recheck your manual pooling program. Try to use jakarta DBCP and see the

Yeshwantha at 2007-7-16 22:58:42 >

# 4

Hi,How i can find the difference when using the execution plan.?Each module many queries are executed. so how i can use @@spid to check the connections. Can u tell me how this is works @@spid? Explain clearlyThanks

memory_leak_problem_efirsthe at 2007-7-16 22:58:42 >

Java programming resources: FAQs, tutorials, compiler and browser download sites, documentation, books lists, IDEs, etc.

Page loading Problem

Developer Tools New Topic

Developer Tools Hot Topic

Developer Tools

All Classified