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!)