About the Load Test Results Store
When you run your load tests, any information gathered during a load test run may be stored in the Load Test Results Store, a SQL database. The Load Test Results Store contains performance counter data and any information about recorded errors. The Results Store database is created by setup for controllers, or created automatically on the first local run of a load test. For a local run or VSTESTHOST.EXE run, the database will be created automatically if the load test schema is not present.
If you modify the controller's results repository connection string to use a different server, the new server will need to have the loadtestresultsrepository.sql script run to create the schema. For information on setting up the Load Test Results Store, see.
You gain access to any load test run data from previous runs by using the Load Test Analyzer which may be launched from the Test Results window or Run Queue window. For more information, see.
Team Edition for Testers also provides named counter sets which collect common performance counters based on a technology. These sets are useful when you are analyzing an IIS server, an ASP.NET server, or a SQL server. All of the data collected with counter sets is stored in the Load Test Results store.
There is a distinction between a counter set and the performance counter data. A counter set is metadata - it defines a group of performance counters that should be collected from a computer that is performing a particular role such as IIS or SQL Server. The counter set is part of the load test definition. Performance counter data is collected based on the counter sets, the mapping of the counter set to a specific computer, and the sample rate.
Queries and Reports
The Load Test Results Store can also be queried using any standard SQL query tools. You can use any SQL reporting tool to create custom reports.
You can look at the results of a load test run while the test is running using the Load Test Monitor. You can look at the results of a load test run after the test is complete using the Load Test Analyzer.
For more information, see the following topics: