Analysis on large result set fails
Question ID: 108074

We are using Performance Center 12.50 and our OS is Windows 2012 Server R2.

When attempting to analyze a large result set from an 8 hour test, the analysis is hung at 49% in Performance Center. When analyzing locally, an error is displayed stating to use SQL server instead of MS Access, then the summary page is missing transactions.

Marked as spam
Posted by (Questions: 159, Answers: 15)
Asked on January 20, 2018 3:51 pm
Answers (1)
Private answer

If full logging was turned on, this could cause the error(s).

If full logging was not enabled, the root cause of the issue is that the result data size too large to be handled by MS Access database. This issue can be resolved by using SQL lite database directly with Analysis.

By default, Analysis is preset to use MS Access with result sets smaller than 2 GB's. You will need to select the recommended format based on the analysis session file size.

* Less than 2 GB - Recommended - Access 2000
* 2 GB to 10 GB - Recommended - SQL Server/MSDE
* More than 10 GB - Recommended - SQLite

In order to process very large result data, you will need to use the appropriate database option with Analysis. However, these option is only available when using the Analysis directly and not via Performance center.

Please follow the below steps to set-up SQL lite database with Analysis:

1) Openthe HPLoadRunner Analysis
2) Go to Tools -> Options
3) Clickthe Database tab
4)Choose SQLite option
5) Click OK

Marked as spam
Posted by (Questions: 17, Answers: 266)
Answered on January 20, 2018 3:52 pm

Welcome back to "EyeOnTesting" brought to you by Orasi Software, Inc.

Scroll to Top