Load Testing – SQL Tracing

Load tests in Visual Studio Team Edition for Testers provide development teams with a way to see how an application acts under various sorts of user load. For applications that use Microsoft SQL Server, SQL trace data can be gathered during load testing and stored for later viewing and analysis. This helps testers to identify queries or stored procedures that may be impacting overall performance.

To enable SQL tracing for a load test, edit the run settings form the test details window for a load test.

Enabling SQL tracing for a load test