Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Troubleshooting Web Application Performance Expand / Collapse
Author
Message
Posted Sunday, April 28, 2013 3:25 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Friday, December 12, 2014 8:08 AM
Points: 52, Visits: 162
Hello,

One of my clients has a few web applications using SQL Server as a backend. One of those applications in particular has a performance problem, namely that logins are taking 10-15 seconds. I need to troubleshoot the issue to first identify whether this issue is related to SQL Server, or something else such as the web server. How can one go about troubleshooting this to identify where the issue lies? Are there any tools or techniques I can use to do this?

Thanks !
Post #1447344
Posted Sunday, April 28, 2013 9:47 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Monday, December 1, 2014 3:42 PM
Points: 364, Visits: 386
Since this is a SQL Server forum, I'll concentrate on SQL Server only, but in reality this investigation should start from the application-end and work down the application stack.

With SQL profiler running, take a baseline of the round trip time from client request to client render complete.

See what queries and procs are being run to build that page, and see how long those queries take as a % of the total round trip.
Post #1447359
Posted Monday, April 29, 2013 1:04 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Thursday, November 20, 2014 4:29 AM
Points: 3,559, Visits: 2,671
You might want to compare the time difference while doing dome operation on your webpage and running the underlying query on sql server to check if there is some issue on SQL side or some other stuff. If you don't know what is underlying query to the page (which is very rare case), you can track the same by performing some operation while running profiler to track down what is happening.
Post #1447382
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse