Extracting and analyzing lab test data

  • Article

This Office product will reach end of support on October 10, 2017. To stay supported, you will need to upgrade. For more information, see , Resources to help you upgrade your Office 2007 servers and clients.

 

Topic Last Modified: 2010-01-19

In addition to using Visual Studio Team System 2008 Test Edition itself to open and analyze data from past test runs, you should also analyze test data with more powerful tools such as Microsoft Office Excel 2007.

Moving data from the lab to the test analysis database

Deploying the lab environment in an isolated network is a best practice. Thus, a Microsoft SQL Server database that contains test data that is collected through Visual Studio Team System 2008 Test Edition will typically be in a separate network from the one that you are connected to when you perform most of the data analysis work. For this reason, it is common to have a process to move test data from the lab environment to a test analysis environment. This can be done with a SQL Server backup and recovery operation of the LoadTest database from one environment to another.

Extracting relevant data from the test database

The first thing to know when you are dealing with the LoadTest database is the test run IDs for the test runs stored in the database. The GetTestRunIDs.sql file in the "Project Server 2007 Performance Lab Kit" contains a Transact-SQL query that can be used to get the list of test run IDs from the database, together with other information useful to identify the test runs.

Once you have the test run ID of a test that you want to analyze, you then have to extract relevant information from the database. The main table for that purpose is LoadTestComputedCounterSample, which contains all the data samples for performance-counter data and key performance indicators from all the test runs. A sample Transact-SQL query that can be used to extract relevant data is included in the ExtractData.sql file in the "Project Server 2007 Performance Lab Kit." This query returns several result sets that can be easily copied and then pasted into an Excel 2007 worksheet.

See Also

Concepts

Planning a Project Server 2007 test lab
Key metrics for Project Server 2007 performance
Setting up a Project Server 2007 test environment
Testing user-initiated read-only operations involving Project Web Access
Testing user-initiated writer operations involving Project Web Access
Testing user-initiated operations involving Project Professional
Testing Project Server 2007 background operations