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.
.gif)
The Load Testing schema references five fact tables:
Load Test Transaction fact table (dbo.Load Test Transaction)
Load Test Details fact table (dbo.Load test Details)
Load Test Page Summary fact table (dbo.Load Test Page Summary)
Load Test Summary fact table (dbo.Load Test Summary)
Load Test Counter fact table (dbo.Load Test Counter).
The Load Testing schema also references nine dimension tables:
Load Test Transaction Dimension dimension table (dbo.Load Test Transaction Dimension)
Load Test Page Summary Dimension dimension table (dbo.Load Test Page Summary Dimension)
Load Test Scenario dimension table (dbo.Load Test Scenario)
Machine dimension table (dbo.Machine)
Load Test Counter Dimension dimension table (dbo.Load Test Counter Dimension)
Result dimension table (dbo. Result)
Run dimension table (dbo.Run Dimension)
Build dimension table (dbo.Build Dimension)
Team Project dimension table (dbo.Team Project) (see Shared Dimensions)
Load Test Transaction Fact Table
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. |
Load Test Details Fact 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. |
Load Test Page Summary Fact 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. |
Page Summary |
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. |
Load Test Summary Fact 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. |
Load Test Counter Fact 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. |
Load Test Transaction 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). |
Load Test Page Summary Dimension Table
The following table describes the columns in the Load Test Page Summary 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). |
Load Test Scenario Dimension Table
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). |
Machine Dimension Table
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). |
Load Test Counter Dimension Table
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). |
Result Dimension Table
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). |
Run Dimension Table
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). |
Build Dimension Table
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 New Build Type. Selected from the Team Builds node in Team Explorer. For more information, see How to: Run a Build on a Build Type. |
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). |