Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

is there a way to split the processing time by individual components? means that

  1. How much time client browser takes to establish the connection with the server.
  2. How much time IIS takes to communicate to SQL?
  3. How much time SQL takes to return the results.
  4. How much time IIS takes to respond back to the client
share|improve this question
add comment

2 Answers 2

I am not aware of a tool that tracks all those stats at once. You could probably acomplish it using wire shark on each of the respective machines. I guess I would ask why do you want to know, probably you have a slow site? Some things you can do to help that are

  1. Turn on Caching http://technet.microsoft.com/en-us/library/cc770229.aspx
  2. Use y-Slow in firefox to see what the size of your page is and why it is rendering slow. This will give you the time it takes the browser to load and how long it takes to get the info from the WFE http://developer.yahoo.com/yslow/
  3. verify that you have your SQL Server setup according to best practices http://technet.microsoft.com/en-us/library/cc263261(office.12).aspx. this best practice doc says it is for 2007 but al most all still applys to 2010.
share|improve this answer
add comment

Great question. You should have a look at SQL Profiler, which provides all the statistics you need, with the exception of browser related ones. Have a look at this Google search for details.

Another option is to track your SQL Server Performance Counters.

Idera recently posted some info about tuning your database for SQL Usage as well.

share|improve this answer
    
We had a debate about linking to Google Search results in SO long back :-) –  Shoban Apr 27 '11 at 6:23
    
I don't think I was part of that discussion so please point me to any sources maintained by stack exchange / moderators of this particular site. –  Muhimbi Apr 27 '11 at 6:44
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.