Test results are stored in a database. There are four types of settings that can be configured:
- How much data to store: Specify what type of information should be saved (reports, test log, etc.).
- Session content: Specify how many details to store in the test log.
- Data storage medium: Specify what database type to use.
- Agent to controller replication: Specify if you want to copy information to the controller about sessions issued by the agents with SQL Server CE-based storage. This information is necessary for waterfall charts.
1. Go to Result Storage node in the Workflow Tree .
2. Configure what data to store by selecting one of the How Much Data to Store property values:
- All: All the resulting data, including a summary report, all result grids, graphs, and all request/response session info (this is the largest part).Use this mode if you would like to view individual request/response info of replayed sessions.
- Partial: All the resulting data, including a summary report, all result grids, graphs, but no request/response session info.
- None: No info result info is stored. You can view the resulting summary report, all result grids and graphs, but they will be deleted once you run another test or close the test. Use this mode for quick practice tests. No other settings will apply in this mode.
3. Select what database type to use by selecting Data Storage .
- Embedded SQL Server CE: Every test run will have its own database file with up to 4 GB of data. It can store a test log with up to 4 million sessions with the average session size (excluding the response body) up to 1 KB.
- SQL Server: Provide your SQL Server to store virtually unlimited test logs.
4. If Embedded SQL Server CE: is selected, the property Save sessions from agents will be available. In distributed tests with SQL Server CE-based storage, the content of the sessions generated on the agents is stored on the agents.
- Select Yes, to copy this content to the controller. This will allow generating waterfall charts for VUs emulated on the agent.
- Select No, to reduce the traffic between agents and controller when the network bandwidth is limited.
5. If SQL Server is selected, enter an SQL Server Connection String property or ...
6. Click the box in the property grid to bring up the connection string dialog
- Enter SQL Server name, authentication type, credentials and database name.
- Click Create/Check DB. If you use a new database, all tables and other database objects will be created automatically. If use an existing database, the connection will be verified.
- If you selected All during step #2, then most of your data storage will be occupied by the request/response bodies that are stored in the test log. You can reduce the amount of stored data by selecting one of the purge options:
- Purge request bodies property (c)
- Non-Errors: Non-Error request bodies are purged and error bodies are not.
- All: All request bodies are purged, no request bodies are stored in the database.
- None: (Default) No request bodies are purged, all request bodies are stored in the database.
- Purge response bodies property (d)
- Static Mime Types: (Default) Response bodies of images, video and other static resources are purged. Dynamic responses meaningful for performance analysis will be stored.
- None: No response bodies are purged, all response bodies are stored in the database.
- Non-Errors: Non-Error response bodies are purged and error bodies are not.
- All: All response bodies are purged, no response bodies are stored in the database.