One of the nice features of Visual Studio 2010 Ultimate is the load testing. This allows you to schedule a set of automated test scenario’s using multiple criteria like number of users, distribution, network latency,… Results of these load tests are stored in a SQL database.
Before you can save the load test results to the database, a database schema must be created,
To create the load test database:
- Open a Visual Studio Command prompt. Browse to the following location: cd c:\Program Files\Microsoft Visual Studio 10\Common7\IDE
In that folder, type the following command:
SQLCMD /S localhost\sqlexpress /i loadtestresultsrepository.sql
Remark:The parameters are case sensitive. You must type uppercase S and lowercase i.