split up the processing time by components

Question

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

Answer 1

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.

Answer 2

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.