Reporting Load Tests Results for Test Comparisons or Trend Analysis
You can generate Microsoft Excel load test reports that are based on two or more test results. Two types of load test reports are available:
Run comparison This report is actually two reports that display side by side comparison data using tables and bar charts.
Trend You can generate trend analysis on two or more reports. The results are displayed using line charts.
Either report can be used to share performance data with stakeholders and convey whether the overall performance and health of the system is getting better or worse.
Report definitions are stored in the load test database. When a report is saved, the definition for the report is saved in the database and can be re-used later.
Also, the spreadsheet file can be shared with stakeholders so that stakeholders do not have to connect to the database to see the report.
If you add comments to a load test, they will appear in the Excel report. For more information, see How to: Add Comments While Analyzing a Completed Load Test Using the Load Test Analyzer and How to: Add a Comment to a Running Load Test Using the Load Test Analyzer.
If you install Visual Studio 2010 Service Pack 1, then you must install Microsoft Office 2010 Service Pack 1 in order for Microsoft Excel reporting to continue functioning correctly. Similarly, installing Microsoft Office 2010 Service Pack 1 requires you to install Visual Studio 2010 Service Pack 1. If you do not install both of the service packs, the Load Test tab will not appear in the Office ribbon for Microsoft Excel.
Create a performance and stress report: You can create reports on your load and Web performance tests, using Microsoft Excel.
Manually create a performance and stress report by using Microsoft Word: You can create reports on your load and Web performance tests manually by copying and pasting summary, table, and graph data to a Microsoft Word document.