Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Working with Load Test Tables

Working with Load Test Tables

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. Typically, this type of data is very useful in your first pass when you analyze the performance of your applications under load. To switch to table view, click Tables on the load test toolbar.

In table view, you can view one table at a time. To switch between the different tables, use the Table drop-down list on the toolbar above the table grid. 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.

NoteNote

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.

NoteNote

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

Agents

Displays summary data for individual agents when you run a load test on a rig with more than one agent. For more information, see The Agents Table.

Errors

Displays a list of errors that occurred during the load test run. For more information, see Analyzing Load Test Errors.

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.

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 from a Load Test Run.

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.

Transactions

Displays a list of transactions that occurred during a load test run. For more information, see The Transactions Table.

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.

The Agents Table

The Agents table displays summary data for individual agent computers. This table is available only when you run a load test on a rig with more than one agent.

The following table lists the columns in the Agents table:

Column Description Visible by Default

Name

The name of the agent computer.

Yes

Total Requests

The total number of Web test requests 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 Requests

The number of Web test requests issued and passed.

No

Failed Requests

The number of Web test requests 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 Test Errors.

Yes

Requests/Sec

The rate per second of requests during the load test run.

No

Cached Requests

The total number of times the request was already cached.

No

Total Tests

The total number of tests run during the load test. This includes the number of times tests passed and failed.

Yes

Passed Tests

The number of tests run during the load test and passed.

No

Failed Tests

The number of tests run during the load test 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 Test Errors.

Yes

Tests/Sec

The rate per second of tests during the load test run.

No

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 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 Test Errors.

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 Test Errors.

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 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 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:

Column Description Visible by Default

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 average elapsed time to execute a transaction during a load test run. For Web tests, think time is included in the calculation. The units are seconds.

Yes

90% Transaction Time

The 90th percentile value for Transaction Time.

No

95% Transaction Time

The 95th percentile value for Transaction Time.

Yes

Response Time

The average response time for a Web 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.

Yes

See Also

Community Additions

ADD
Show:
© 2015 Microsoft