Solved

How to troubleshoot poor response time?

Posted on 2008-06-20
6
676 Views
Last Modified: 2013-12-24
Hi Experts,
I'm having issues with poor performance on my web site and I need some guidence as to how to trouble shoot the problem.  

In short, my web pages are taking a long time to load and sometimes even timeout.  

Here's some general info about the site..
  My server is a decent one Dell 2850 with 4 G of RAM
  The CPU Usage is low - single digits with occassional spikes up
  The content of my web page is data, often large tables with up to 1,000 rows
  The database is not very big, most tables 3-5,000 records with a few around 100,000
  Visits to the site are only about 600

I am using window servers, one for database and one for web server.  IIS 6
  Coldfusion 8  and   SQL Server 2005

Any guidence on how I can troubleshoot the problem?  
* I can't even tell if its a database issue, web service, networking, bandwidth or coldfusion problem...    

Please provide whatever specifics you can, I'm a bit of newbie this this area (obviously!)
Thanks,


0
Comment
Question by:gdemaria
  • 2
  • 2
  • 2
6 Comments
 
LVL 15

Accepted Solution

by:
DonKronos earned 250 total points
ID: 21834992
First I would check out the bandwidth on the Internet connection.  What is your upload bandwidth?

Second, I would run the SQL queries on the database server.  Is the response "good"?

Third, run the same SQL queries on the WEB server.  Is the response "good"?

If all of this checks out ok then one of the other zones might be able to help you.
0
 
LVL 8

Assisted Solution

by:sbagireddi
sbagireddi earned 250 total points
ID: 21835005
You need to get your hands on some performance testing tools like Jmeter.
Here are some open source tools:
http://www.opensourcetesting.org/performance.php

If you finally nail it down to database issues then you can use the SQL server profiler:

http://msdn.microsoft.com/en-us/library/ms187929.aspx
0
 
LVL 39

Author Comment

by:gdemaria
ID: 21835123
Thanks Don,

> First I would check out the bandwidth on the Internet connection.  What is your upload bandwidth?

I have a 4 Mbps pipe with bursting.   Which we just increased from 1/2 the same week we started seeing these issues.  Odd, eh?

> Second, I would run the SQL queries on the database server.  Is the response "good"?
Yup, I run these queries all the time through management studio, they are pretty well tuned and run at a decent speed.  However, this is just me doing one at a one sql statements.

> Third, run the same SQL queries on the WEB server.  Is the response "good"?
Hmmm, not sure how I can do this.  In the debug info, I can see the query times and they are sometimes not as good and sometimes too long.  I am a bit concerned that I have some deadlocks going sometimes, but my queries are just SELECT so that should not be an issue.

0
NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

 
LVL 15

Expert Comment

by:DonKronos
ID: 21835413
I agree that deadlock should not be a problem.

Is there heavy network traffic between the servers?

Do you have a firewall between the WEB server and the database server?

Are the servers on the same LAN?

If the queries run fast on the database server and not to fast from the web server then I would zero in on the connection between the machines.

SBs suggestion on the performance tools is also a good path to persue.

No magic answer to your problem.  You just have to keep eliminating possible bottlenecks until you find the real one.  :( :(
0
 
LVL 8

Expert Comment

by:sbagireddi
ID: 21835478
0
 
LVL 39

Author Comment

by:gdemaria
ID: 21835522
sbagireddi,

I appreciate the effort, but we're no longer using Windows NT or Coldfusion 4 (circa 1999)

 :)

But I will try to find a recent equivalent !

Thanks for the idea.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

by Mark Wills Attending one of Rob Farley's seminars the other day, I heard the phrase "The Accidental DBA" and fell in love with it. It got me thinking about the plight of the newcomer to SQL Server...  So if you are the accidental DBA, or, simp…
Article by: kevp75
Hey folks, 'bout time for me to come around with a little tip. Thanks to IIS 7.5 Extensions and Microsoft (well... really Windows 8, and IIS 8 I guess...), we can now prime our Application Pools, when IIS starts. Now, though it would be nice t…
In this video I am going to show you how to back up and restore Office 365 mailboxes using CodeTwo Backup for Office 365. Learn more about the tool used in this video here: http://www.codetwo.com/backup-for-office-365/ (http://www.codetwo.com/ba…
Both in life and business – not all partnerships are created equal. As the demand for cloud services increases, so do the number of self-proclaimed cloud partners. Asking the right questions up front in the partnership, will enable both parties …

910 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now