Analyzing Load Test Results in the Tables View of the Load Test Analyzer
When you view the results of a load test run, you can display different panes that provide you with different ways to analyze the data. You can view the data as a graph, to see how it changes over time, or you can view the data as detailed tables.
To switch to table view, click Tables on the load test toolbar. To switch between the different tables, use the Table drop-down list on the toolbar above the table grid. In table view, you can view up to four tables at a time. For more information, see How to: Tile Load Test Tables.
Most numeric values displayed in a table for performance counters are cumulative over the whole load test run. Columns named Last are an exception, and represent the value from the most recent sampling interval.
Note
Columns named Last are available only while a load test is executing. After a load test is completed, these columns are not available.
You can sort most tables by clicking the title of the column that you want to sort on. By default, some tables do not display all available columns. You can add columns to tables, if columns are available. To add columns, right-click the table and then click Add/Remove Columns.
Note
You can copy the data from a table into other applications such as Excel for additional analysis.
The Load Test Tables
The following table lists the tables that are available to analyze load test runs.
Table Name |
Description |
|---|---|
Errors |
Displays a list of errors that occurred during the load test run. For more information, see Analyzing Load Tests Results Using the Load Test Analyzer. |
Pages |
Displays a list of pages accessed during a load test run. Some data in this table is available only after a load test has completed. For more information, see How to: View Web Page Response Time in a Load Test Using the Load Test Analyzer. |
Requests |
Displays details for individual requests issued during a load test. This includes all HTTP requests, and dependent requests such as images. For more information, see The Requests Table. |
SQL Trace |
Displays the results of SQL tracing. This table is available only after a load test has completed, and only if SQL tracing was used during the test. For more information, see How to: View SQL Trace Data in Load Tests Using the SQL Trace Table. |
Tests |
Displays details for individual tests run during a load test. For more information, see The Tests Table. |
Thresholds |
Displays a list of threshold rule violations that occurred during the load test run. For more information, see Analyzing Threshold Rule Violations in Load Tests Using the Load Test Analyzer. |
Transactions |
Displays a list of transactions that occurred during a load test run. For more information, see The Transactions Table. |
Agents |
Displays only if your load test is using a test controller and test agents. Displays a list of the agents that were used during the load test run. The Agents table includes how many requests the agent tested and of those requests, how many failed. Additionally, the Agents table includes the number of tests in the load tests test mix that the agent tested and of those, how many failed. |
Test Details |
Displays details for the tests included in the test mix for the load test. The details include the name of the test, the scenario that the test was in, the time that the test started, the length of time it took the test to run, and the test outcome indicating if the test passed or failed. If the test failed, a link is present in the Details column. You can click the link which will take you to the Web Performance Test Editor with the failed request highlighted. |
Tasks
Tasks |
Associated topics |
|---|---|
Arrange how tables are displayed while using the Tables view in the Load Test Analyzer: You can specify how many table to display and how you want the tables to be tiled. |
|
Analyze errors in your Web performance test: The Tables view in the Load Test Analyzer, includes the Errors table, which you can use to help debug your Web application. |
|
Analyze SQL Trace data in your Web performance test: You can use the SQL Trace table to view the SQL trace data that was collected during your Web performance test. |
Collecting Percentile Data
Some load test tables can contain additional columns, which include percentile data and response times broken into groups based on network emulation. By default, this data is not collected. To collect this data, in the Load Test Editor, under the Run Settings node, select the specific run setting node to change. In the Properties window, for the Timing Details Storage property, select StatisticsOnly or AllIndividualDetails. For more information, see How to: View Web Page Response Time in a Load Test Using the Load Test Analyzer.
The Requests Table
The Requests table displays details for individual requests issued during a load test. This includes all HTTP requests, and dependent requests such as images. The table lists requests by test and scenario, because one request can be included in many tests and scenarios.
The following table lists the columns in the Requests table:
Column |
Description |
Visible by Default |
|---|---|---|
Request |
The URL of the request. For example, home.html, or orange-arrow.gif. |
Yes |
Scenario |
The name of the scenario. |
Yes |
Test |
The name of the test. |
Yes |
Total |
The total number of this Web performance test request issued during the load test run. The total includes passed and failed requests, but does not include cached requests, because they are not issued to the Web server. |
Yes |
Passed |
The number of times the request was issued and passed. |
No |
Failed |
The number of times the request was issued and failed. The entries in this column appear as hyperlinks. You can click any hyperlink to view a list of the individual errors in the Load Test Errors dialog box. For more information, see Analyzing Load Tests Results Using the Load Test Analyzer. |
Yes |
Cached |
The total number of times the request was already cached. |
No |
Requests/Sec |
The rate per second of the request during the load test run. |
No |
Passed/Sec |
The rate per second of this request during the load test run, for the instances of this request that passed. |
No |
Failed/Sec |
The rate per second of this request during the load test run, for the instances of this request that failed. |
No |
First Byte Time |
The average time to receive the first byte of the response, measured from the time the request was sent to the Web server. The units are seconds. |
No |
Response Time |
The average time to receive the entire response to a request, measured from the time the request was sent to the Web server. The units are seconds. |
Yes |
Content Length |
The average length of the content of the response to the request. The units are bytes. |
Yes |
The Tests Table
The Tests table displays details for individual tests run during a load test. The table lists tests by test and scenario, because one test can be included in many scenarios.
The following table lists the columns in the Tests table.
Column |
Description |
Visible by Default |
|---|---|---|
Test |
The name of the test. |
Yes |
Scenario |
The name of the scenario. |
Yes |
Total |
The total number of times the test was run in the scenario. This includes the number of times the test passed and failed. |
Yes |
Passed |
The number of times the test was run in the scenario and passed. |
Yes |
Failed |
The number of times the test was run in the scenario and failed. The entries in this column appear as hyperlinks. You can click any hyperlink to view a list of the individual errors in the Load Test Errors dialog box. For more information, see Analyzing Load Tests Results Using the Load Test Analyzer. |
Yes |
Tests/Sec |
The rate per second of the test during the load test run. |
Yes |
Passed/Sec |
The rate per second of this test during the load test run, for the instances of this test that passed. |
No |
Failed/Sec |
The rate per second of this test during the load test run, for the instances of this test that failed. |
No |
Test Time |
The average time to execute the test during the load test run. The units are seconds. |
Yes |
90% Test Time |
The 90th percentile value for Test Time. |
No |
95% Test Time |
The 95th percentile value for Test Time. |
Yes |
Requests/Test |
The average number of requests in the test if it is a Web performance test. |
No |
The Transactions Table
The Transactions table displays a list of transactions that occurred during a load test run. Transactions refer to either transactions defined in a Web performance test, or timers defined in a unit test. Transaction does not refer to database transactions.
The following table lists the columns in the Transactions table.
Note
To view all columns, you must enable the Timing Details Storage property that is associated with the active run setting. For more information, see How to: Specify the Timing Details Storage Property for a Load Test Run Setting.
Column |
Description |
Visible without timing details |
|---|---|---|
Transaction |
The name of the transaction. |
Yes |
Scenario |
The name of the scenario. |
Yes |
Test |
The name of the test. |
Yes |
Total |
The total number of transactions issued during the load test run. |
Yes |
Transaction Time |
The time to execute the transaction during a load test run. For Web performance tests, think time is included in the calculation. The units are seconds. |
No |
Response Time |
The response time for the Web performance test transaction in a load test run. Response Time is different from Transaction Time in that Response Time does not include any think time that occurred during the transaction. The units are seconds. |
No |
Ave. Transaction Time |
The average transaction time. This time includes think times. For example, if you have three requests and each has a think time, this time will include those think times and the actual time to execute requests. |
No |
Ave. Response Time |
The average response time for a Web performance test transaction in a load test run. Response Time is different from Transaction Time in that Response Time does not include any think time that occurred during the transaction. The units are seconds. |
No |
Min Response Time |
This does not include think times. |
No |
Max Response Time |
This does not include think times. |
No |
Median Response Time |
This does not include think times. |
No |
90% Response Time |
The 90th percentile value for Transaction Time. This does not include think times. .gif "Note") Note
This is different from Visual Studio Team System 2008, which used the 90% Transaction Time value.
|
No |
95% Response Time |
The 95th percentile value for Transaction Time. This does not include think times. Note
This is different from Visual Studio Team System 2008, which used the 95% Transaction Time value.
|
No |
99% Response Time |
The 99th percentile value for Transaction Time. This does not include think times. |
No |
Std Dev Response Time |
This does not include think times. |
No |
See Also
Tasks
How to: Access Load Test Results for Analysis
Concepts
Analyzing Load Test Results in the Graphs View of the Load Test Analyzer