At the end of a big web application project I needed to run a load test that will enable me to understand the limitations and drawbacks. So I had everything set up, the lab at IBM, the software and etc.
I executed the test several times in different configurations, and at the end of a very long day I took the test results which includes the:
- MSSQL 2005 database backup that stores the test results.
- The *trx files within the TestResults folder.
At the next day, I got back to the office for the analyzing phase of the load tests. So basically all I wanted to do is view the load test results from a lab session I did on a new machine back in the office.
Simple, right? wrong!!!
Here is how you will save time and pain killers when you will need to view load test results.
Here is how not to do it:
I opened Visual Studio (2008 Team Suite).
In the Test menu I have selected Windows and Test Runs:
On the Test Runs window I have opened the TestResults folder:
Then I have tried to open one of the tests in the list:
I double clicked it and got:
Basically, what it say is that it cannot read the results from the database. Why, ohoo why?
How did I try to solve it?
- I have checked the database and verified that it is configured for remote access.
- Tried to connect to the database with the SQL Management.
- I opened the Administrate Test Controller:
and verified the connection string:
Everything was pitchy!
Apparently Microsoft had something else in mind…
How Should You Do It?
Open a test project.
Open a load test.
On the load test toolbar, click Open and Manage Results
The Open and Manage Load Test Results dialog box is displayed.
Enter a controller name to find load test results. Select <local> to access results stored locally.
In Show results for the following load test, select the load test whose results you want to view.
In the Load test results list, click a result.
The load test analyzer opens and the results appear.
That's it. I hope this will save you some time!
I personally think that this is a bad design of a user interface.
What do you think?