About the Load Test Results Repository
When you run your load tests, any information gathered during a load test run may be stored in the Load Test Results Repository, which is a SQL database. The Load Test Results Repository contains performance counter data and any information about recorded errors. The Results Repository 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 must have the loadtestresultsrepository.sql script run to create the schema. For information about how to set up the Load Test Results Repository, see How to: Create a Results Repository Using SQL.
Visual Studio Team System Test Edition 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 Repository.
There is a difference 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.
You can access previous load test results from the Load Test Editor by using the Open and Manage Load Test Results dialog box. For more information, see Managing Results in a Repository.
You can also access data from previous load test runs by using the Load Test Analyzer which may be opened from the Test Results window or Run Queue window.
You can query the Load Test Results Repository by using any standard SQL query tools. You can use any SQL reporting tool to create custom reports.
You can view the results of a load test run while the test is running by using the Load Test Monitor. You can view the results of a load test run after the test is complete using the Load Test Analyzer.
For more information, see the following topics: