Load Testing Schema

Artykuł
11/16/2012

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:

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

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 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).

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 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).

Udostępnij za pośrednictwem