How to determine where load test results are saved in Visual Studio 2010?

Question

I am running some load tests using Visual Studio 2010. I was not able to figure out how to set where the test results will be saved, and it seems that I do not have the test results to view after the test runs.

I have a general idea that you should provide an SQL connection string that defines the SQL server with the tables installed on it.

Where to set the connection string for local test runs? Is it possible to configure VS2k10 to save my test results in a local file?

Please note that local SQL databases, such as SQL Express, are not allowed in my environment.

Answer 1

If you find yourself in a situation where you have not configured the database to store the test results from Load Loader VS 2010, this will help.

The default installation of VS 2010 will not contain Microsoft Visual Studio Test Controller 2010 .

To create the necessary tables to store the test results, all you need to do is run the loadtestresultsrepository.sql script for your database.

You will find this script at:
x86 - C: \ Program Files \ Microsoft Visual Studio 10 \ Common7 \ IDE
x64 - C: \ Program Files (x86) \ Microsoft Visual Studio 10.0 \ Common7 \ IDE

Taken from: MSDN: How to create a repository of load test results using SQL

Answer 2

Visual Studio strictly requires SQL Server for test load storage. If you do not have a SQL Server database, you cannot save test run data. All you can do is view the result immediately after the test run and, possibly, copy and paste the test data into Excel. After you close the result, everything went well.

However, the database does not have to be on your local machine. Is it likely that you can access SQL Server elsewhere on your network?

To configure the database before use, you need to run the "Microsoft Visual Studio Test Controller 2010 Customization Tool" (located in the folder with the Visual Studio source menu).

The connection string is configured in the Test menu (menu)> Manage Test Controllers. In this dialog box, you can select Controller (or "Local - No controller" for local tests), and you can also set the connection string in the repository of load test results.