SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Troubleshooting Web Application Performance


Troubleshooting Web Application Performance

Author
Message
Like2SQL
Like2SQL
Old Hand
Old Hand (364 reputation)Old Hand (364 reputation)Old Hand (364 reputation)Old Hand (364 reputation)Old Hand (364 reputation)Old Hand (364 reputation)Old Hand (364 reputation)Old Hand (364 reputation)

Group: General Forum Members
Points: 364 Visits: 223
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 !
Mansfield
Mansfield
Say Hey Kid
Say Hey Kid (702 reputation)Say Hey Kid (702 reputation)Say Hey Kid (702 reputation)Say Hey Kid (702 reputation)Say Hey Kid (702 reputation)Say Hey Kid (702 reputation)Say Hey Kid (702 reputation)Say Hey Kid (702 reputation)

Group: General Forum Members
Points: 702 Visits: 394
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.
sqlnaive
sqlnaive
SSCertifiable
SSCertifiable (6.4K reputation)SSCertifiable (6.4K reputation)SSCertifiable (6.4K reputation)SSCertifiable (6.4K reputation)SSCertifiable (6.4K reputation)SSCertifiable (6.4K reputation)SSCertifiable (6.4K reputation)SSCertifiable (6.4K reputation)

Group: General Forum Members
Points: 6393 Visits: 2774
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.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search