Export (0) Print
Expand All

Load Testing Schema

The following diagram shows the relationships between the four Load Test fact tables and the related measures (dimensions) in the data warehouse.

Schema showing relationships among dimensions

The Load Testing schema references five fact tables:

The Load Testing schema also references nine dimension tables:

The following table describes the columns in the Load Test Transaction fact table.

Column

Description

__ID

Identifying number for the record in the table (used internally).

Sequence

Identifying number for the sequence (used internally).

Test

The name of the load test.

Transactions

The number of transactions executed during a load test. This can be summarized by the transaction dimension.

Response Time

The average response time for the pages read by the load test.

Elapsed Time

The average elapsed time for the transactions that occurred in the load test.

__LastUpdatedTime

Date and time the record was last inserted or updated.

__TrackingID

Identifying number that is used by the warehouse infrastructure to track the record.

Load Test Transaction

Foreign key to the Load Test Transaction Dimension dimension table

Build

Foreign key to the Build dimension table.

Run

Foreign key to the Run dimension table.

Load Test Scenario

Foreign key to the Load Test Scenario dimension table.

Result

Foreign key to the Result dimension table.

Team Project

Foreign key to the Team Project dimension table.

The following table describes the columns in the Load Test Details fact table.

Column

Description

__ID

Identifying number for the record in the table (used internally).

Sequence

Identifying number for the sequence (used internally).

Test

The name of the load test.

Total Tests

The total number of tests that were executed as a part of the load test.

Failed Tests

The number of tests that failed during the execution of the load test.

Average Duration

The average duration for the tests executed during the load test.

__LastUpdatedTime

Date and time the record was last inserted or updated.

__TrackingID

Identifying number that is used by the warehouse infrastructure to track the record.

Build

Foreign key to the Build dimension table.

Run

Foreign key to the Run dimension table.

Load Test Scenario

Foreign key to the Load Test Scenario dimension table.

Result

Foreign key to the Result dimension table.

Team Project

Foreign key to the Team Project dimension table.

The following table describes the columns in the Load Test Page Summary fact table.

Column

Description

__ID

Identifying number for the record in the table (used internally).

Sequence

Identifying number for the sequence (used internally).

Test

The name of the load test.

Response Time

The average response time for the pages read by the load test.

Page Count

The number of Web page reads that occurred in the load test.

__LastUpdatedTime

Date and time the record was last inserted or updated.

__TrackingID

Identifying number that is used by the warehouse infrastructure to track the record.

PageSummary

Foreign key to the Load Test Page Summary dimension table.

Build

Foreign key to the Build dimension table.

Run

Foreign key to the Run dimension table.

Scenario

Foreign key to the Load Test Scenario dimension table.

Result

Foreign key to the Result dimension table.

Team Project

Foreign key to the Team Project dimension table.

The following table describes the columns in the Load Test Summary fact table.

Column

Description

__ID

Identifying number for the record in the table (used internally).

Start Time

Date and time the build began.

Actual Duration

The actual duration for which the load test ran.

LoadTestDuration

The duration the user specified for the load test.

LoadTestWarmupTime

Warm-up time for the load test. During this time performance data is not collected.

__LastUpdatedTime

Date and time the record was last inserted or updated.

__TrackingID

Identifying number that is used by the warehouse infrastructure to track the record.

Build

Foreign key to the Build dimension table.

Run

Foreign key to the Run dimension table.

Result

Foreign key to the Result dimension table.

Team Project

Foreign key to the Team Project dimension table.

The following table describes the columns in the Load Test Counter fact table.

Column

Description

__ID

Identifying number for the record in the table (used internally).

Value

Values collected by the counters during the execution of the load test. These values can be analyzed using the attributes in the Counter ID dimension. Depending on the type of counter that is taking the measurement, the value in this measure has different meanings, for example, the amount of available memory, the number of requests per second, and so on.

__LastUpdatedTime

Date and time the record was last inserted or updated.

__TrackingID

Identifying number that is used by the warehouse infrastructure to track the record.

Build

Foreign key to the Build dimension table.

Run

Foreign key to the Run dimension table.

Result

Foreign key to the Result dimension table.

Counter ID

Foreign key to the Load Test Counter Dimension dimension table.

Machine

Foreign key to the Machine dimension table.

Team Project

Foreign key to the Team Project dimension table.

The following table describes the columns in the Load Test Transaction Dimension table.

Column

Description

__ID

Identifying number for the record in the table (used internally).

Transaction

The name of the transaction associated with measurements in the Load Test Transaction measure group. This enables a list of all transactions, and their corresponding response times and frequencies to be generated for a particular load test result, or a cross many load test results.

__LastUpdatedTime

Date and time the record was last inserted or updated.

__DimensionMemberActive

Value describing whether the dimension member has been fully populated (used internally).

The following table describes the columns in the Load Test Transaction Dimension table.

Column

Description

__ID

Identifying number for the record in the table (used internally).

Url

The URL of the Web page used when measuring the Page Count and Response Time measures of the Load Test Page Summary measure group.

__LastUpdatedTime

Date and time the record was last inserted or updated.

__DimensionMemberActive

Value describing whether the dimension member has been fully populated (used internally).

The following table describes the columns in the Load Test Scenario dimension table.

Column

Description

__ID

Identifying number for the record in the table (used internally).

Load Test Scenario

The scenario used for measurements found in the Load Test Transaction and Load Test Details measure groups.

__LastUpdatedTime

Date and time the record was last inserted or updated.

__DimensionMemberActive

Value describing whether the dimension member has been fully populated (used internally).

The following table describes the columns in the Machine dimension table.

Column

Description

__ID

Identifying number for the record in the table (used internally).

Machine

Name of the computer that is used.

__LastUpdatedTime

Date and time the record was last inserted or updated.

__DimensionMemberActive

Value describing whether the dimension member has been fully populated (used internally).

The following table describes the columns in the Load Test Counter Dimension table.

Column

Description

__ID

Identifying number for the record in the table (used internally).

Counter ID

Identifying number for the counter (used internally).

Counter Object

The Load Test Counter object that is used in measuring activity during the load test. This includes counters such as Memory, Network Interface, or Requests. These counters relate to the Value measure in the Load Test Counter measure group described earlier. Finer granularity for interpreting the meaning of this attribute is that is contained in the Counter attribute of the Counter ID dimension.

Counter

Identifies the specific counter in the counter object to which the Value measure in the Load Test Counter measure group is associated. For example, for the Request counter object, the values contain elements identified by the specific counter such as Average Response Time, Cached Requests, Failed Requests, and so on.

Counter Instance

Identifies the counter instance associated with the Value measure of the Load Test Counter measure group. For example, a counter instance may indicate a specific network card associated with the measurement of Bytes Received per second, Counter in the Network Interface counter object.

Counter Result

Boolean value that indicates that the current counter is used to determine the overall result.

HigherIsBetter

A flag that indicates whether the value measured by this counter instance is better when the value is greater. For example, it is better to have greater throughput for the Bytes Received per Second counter, but it is not better to have greater memory consumption for the Average Test Time measurement. This enables reports to be created that indicate improvements from one run of a load test to another.

__LastUpdatedTime

Date and time the record was last inserted or updated.

__DimensionMemberActive

Value describing whether the dimension member has been fully populated (used internally).

The following table describes the columns in the Result dimension table.

Column

Description

__ID

Identifying number for the record in the table (used internally).

Result ID

Identifying number for the result (used internally).

Result

The name of the Test Result of the load test. By default, this is the timestamp of the time at which the load test was run.

Test

The name of the load test.

Test Type

The type of test associated with the test result. For load tests, this will always be Load Test.

Test Description

A description of the test when the load test result was run.

Parent Result

The key of the parent test result that indicates the result that contained the current result.

Result Root

Value describing whether the result record is a root result that indicates that the result represents the outer-most test result.

Error Message

A string representing the error message for the test result.

Load Test Agent List

The list of agent computers that were used to generate the load test.

End Time

The finish time for the load test.

__LastUpdatedTime

Date and time the record was last inserted or updated.

__DimensionMemberActive

Value describing whether the dimension member has been fully populated (used internally).

The following table describes the columns in the Run dimension table.

Field

Description

__ID

Identifying number for the record in the table (used internally).

Run ID

Identifying number for the run (used internally).

Run

The test run that produced the load test results.

Run Description

The description of the test run that produced the load test results.

Remote Run

A True/False flag that indicates if the test run that produced the load test results was a remote test run.

__LastUpdatedTime

Date and time the record was last inserted or updated.

__DimensionMemberActive

Value describing whether the dimension member has been fully populated (used internally).

The following table describes the columns in the Build dimension table. The table contains one row for each team build.

Field

Description

__ID

Record ID for the table (used internally).

Build Artifact Moniker

Identification number that is used to link an object, such as a work item, with a specific build.

Build

Number or name used to uniquely identify the build.

Build Type

Name of the build type set in the New Team Build Type Creation Wizard. For more information, see How to: Create a Build Definition.

Selected from the Team Builds node in Team Explorer. For more information, see How to: Queue or Start a Build Definition.

Drop Location

The server and share where the completed build will be put.

Build Start Time

Date and time the build began.

__LastUpdatedTime

Date and time the record was last inserted or updated.

__DimensionMemberActive

Value describing whether the dimension member has been fully populated (used internally).

Community Additions

ADD
Show:
© 2014 Microsoft