Network Traffic Analysis
I have a poorly performing web site that I jsut can't seem to track the problem. My website is making a call to the sql database then returning that data and rendering the page. Normally this page can load in about 2 seconds but lately I am seeing up to 14 seconds. It is very intermiitant in that I can refresh the page and get 2 seconds one time then refresh again and receive 6 seconds. the architecture is web server in dmz zone of firewall and sql inside secure zone. No changes have been made to sql or web servers. there is a load balancer that serves up web server but this was bypassed with similar results. Question is " how can I identify how long it is taking for the traffic from the point the request is made at the web server to the sql server then back to the web server?" I have a staging environment with the same DB and similar architecture that does not experience the issue.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Matt V
I would guess the database query is your bottleneck, trying running the SQL Query Analyzer and see if you get different results running the same query over and over. If the query is sound, then I would check your firewall logs to see if there is a delay between the LAN and DMZ.
seconding pergr recommendation. Packet capture, then look for unexpected delays between the HTTP packets and the SQL packets.