Profiling With Visual Studio Team System

Question

Hi,

I'm using Visual Studio Team System 2008 to run Load Tests.

I have a test that executes a web service request and I would like to know how much time was spent in each layer of my application e.g.

Time spent in IIS, Time spent in my Server application Time spent in SQL Server

Can I get this sort of information by setting the performance counters in my load test properly?

Thanks