Testing Intelligence Server Performance

In addition to testing reports and documents for execution and accuracy between projects, Integrity Manager can determine how long it takes an Intelligence Server to execute a given set of reports or documents. You can execute the reports/documents in the integrity test multiple times to get a better idea of the average time it takes to execute each report or document.

In a performance test, Integrity Manager records the time it takes to execute each report/document. If the reports/documents are being executed more than once, Integrity Manager records each execution time. You can view the minimum, maximum, and average execution time for each report/document in the Results Summary area. In a comparative integrity test, you can also view the difference in time between the baseline and target reports/documents.

By default, Integrity Manager only records the execution times for successful report/document execution cycles. To record the times for failed cycles, in the Performance category of the Advanced Options dialog box, select the Include Time from Errors check box.

To Execute a Performance Test

Before you begin, review the Performance test best practices.

Start > All Programs > MicroStrategy > Integrity Manager.
Select the File menu > Create Test.
Select the type of test to run and click Next.
- To test the performance against an Intelligence Server, select Single-project integrity test.
- To compare two previously executed performance tests, select Baseline-versus-baseline integrity test.
  Other types of integrity test are not recommended for performance testing.
Enter the information required on each page.
On the Select Execution Settings page, in the Concurrent Jobs field, enter 1 to run only one report or document at a time.
To test the performance of either reports or documents, on the Select Processing Options page, perform one of the following options:
- Select at least one processing option for Reports, then select the Report Performance check box. In the Report Cycles field, enter the number of times to execute each report.
- Select at least one processing option for Documents, then select the Document Performance check box. In the Document Cycles field, enter the number of times to execute each document.
To record the execution time for failed report/document execution cycles:
1. On the Select Processing Options page, click Advanced Options.
2. The Advanced Options dialog box opens, click Performance.
3. Select the Include Time from Errors check box.
4. Click OK.
Click Run.
To view the results of the test, right-click in the column headers in the Results Summary area and select the columns that you want to view.
- For a single-project integrity test, the relevant columns are the three Base columns.
- For a baseline-versus-baseline integrity test, additional relevant columns include the Target and Difference columns. The Difference columns list the difference between the times for the base and target.

Testing Intelligence Server Performance

To Execute a Performance Test

Related Topics