Software Performance and Load Testing / Application Optimization

Formerly the site of Gray Test Consulting, I am now using the site for sharing information about software testing best practices

Results Database

This series of posts dissects the Visual Studio Load Testing Results Database.

Part 1–Intro to the Schema

Describes the layout and relationships of the tables and views for the LoadTest2010 results database.

A look at the built in Stored Procedures and how some of them get used for building results and reports.

Learn about the built in stored procedures and views used by the “Excel Reporting” feature of Loadtest results.

Start enhancing the results database by adding new views that will allow you to get more filtering and details options.

Add stored procedures that allow you to calculate summary tables on partial result sets or filtered by several characteristics.

Add a few tables to the database to hold “Warehouse Data” and modify two of the built in sprocs to have the tables automatically populated.