Wrox Programmer Forums
SQL Server 2000 General discussion of Microsoft SQL Server -- for topics that don't fit in one of the more specific SQL Server forums. version 2000 only. There's a new forum for SQL Server 2005.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the SQL Server 2000 section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Old January 9th, 2006, 02:20 AM
Registered User
Join Date: Dec 2005
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default Page Loading Problem


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?
Old January 9th, 2006, 12:43 PM
Friend of Wrox
Join Date: Dec 2005
Posts: 146
Thanks: 0
Thanked 1 Time in 1 Post

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

Similar Threads
Thread Thread Starter Forum Replies Last Post
Page is Loading too Slow kornshell Classic ASP Basics 7 October 16th, 2008 09:28 AM
Loading a html page using php Apocolypse2005 Beginning PHP 1 August 4th, 2008 10:21 AM
Slow page Loading yadavrahul2k5 ASP.NET 2.0 Professional 5 August 13th, 2007 07:12 AM
.net page loading is slow angshujit .NET Framework 1.x 1 December 26th, 2006 07:53 AM
Page Loading very slowly mahulda ASP.NET 1.0 and 1.1 Basics 2 April 1st, 2004 11:06 AM

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.