How to: Select a Load Test Results Repository
You are not limited to a local results store. Frequently, load tests are run on a remote set of Agent computers. Agents, together with a controller are called a rig. A rig is capable of generating more simulated load than any single computer. Test results from your agents or your local computer can be saved to any SQL server on which you have created a load test results store. In either case, you must identify where to store your load test results using the Administer Test Controllers window.
For more information about how to set up the SQL tables, see How to: Create a Results Repository Using SQL
For more information about agents, see Controllers, Agents, and Rigs.
Identify a results store for load test data
From the Test menu, click Administer Test Controllers. The Administer Test Controller dialog is displayed. If you are using a rig, you must select a controller.
In the Load Test Results Connection String, click (…) to display the Connection Properties dialog box.
In Server Name, type the name of the server where you have run the LoadTest scripts.
If you are using SQL Express on your local machine for the load test store, enter <computername>\sqlexpress (for example, MyComputer\sqlexpress). For more information, see How to: Create a Results Repository Using SQL.
Under Log on to the server, you can choose Use Windows Authentication. You can specify the username and password, but you need to select the option Save my password if you do.
Under Connect to a database, choose Select or enter a database name. Select LoadTest from the drop-down list box.
Click OK. You can test the connection by clicking Test Connection.
Click Close in the Administer Test Controller dialog box.