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?

DevTeam:
Without looking at your system it is hard to tell. In your case I would suggest using SQL Profiler to monitor the queries being sent to your SQL Server. In particular you want to look at the duration of the queries. If your SQL Server is the bottleneck you will see some queries taking a long time. Then you can go an optimize those queries.

Profiler may also reveal if your use of the api's like jdbc could use some improvement. For example if you are opening a cursor through the API and then fetching the rowset 1 row at a time then you are causing needless roundtrips to the Server.

David Lundell
Principal Consultant and Trainer
www.mutuallybeneficial.com