Load testing Microstrategy Web Reports and Documents

Load testing web

In almost every project, the architects will need to publish the repornse time of ther BI systems. To get the response time from the statistics is easy. However we need a system that can simulate a real time scenario, so that the actual capacity or response time of the BI systems can be estimated. A system that performs quiet well for a single user coulf fail, when 100 such users access the system at the same time. In this article we will see how to quickly set up a performance test for your web reports and dashboards. We will use Jmeter an open source graphical testing tool

Jmeter setup:-

I have shows below the minimal settings that you will need to stress test your system. You can follow the documentation for advanced settings.

• Provide a test plan name.

• Add Thread Group.

• Add HTTP Sampler. This is where you define the hostname, port and the url to test.

Once you provide the hostname, proptocol, and port, you need to add the path for report / document execution. Add the login credentials to the URL, eg:- &uid=username&pwd=password

This is needed for automatic login and execute the report. Remember to set your login method to standard during the time of test.

Now to view the results, use any of the listener outputs. like summarised view, tree view. I am using view results in table. You are now set to do the test. Lets look at the output.

The average response time is about 597 ms . Enable statistics from your web admin page and see the results.

Is shows 500 ms. So with this test data, you can say that the reports average response time is about 600 sec, with a deviation of about 140 ms for 10 concurrent access.