Report Performance

[TejaSurapaneni]

Hi all,

Operating System: LIN X64 .
SAS Version: 9.4

We want to calculate the output parameters for VA and set a benchmark figure and based on the benchmark figure we will measure whether the VA environment is slow or normal.


The sample output parameters are like:

1) How much time it is taking to open the landing / home page after user credentials are provided.

2) How much time it is taking to open a particular report when user clicks on view report.

3) How much time it is taking to load all the charts in that particular report.
4) How much time it is taking to load all the charts in that particular report when an iteration parameter / drop down is changed.
5) In similar lines some other parameters.


Is it possible to measure / calculate these parameters?

If yes, Could you please help us where can we get these information and in which logs all these information are stored?


Note: We don't want to enable audit report, it will give which user opened / accessed which report. Our requirement was not that.

[JuanS_OCS]

Hi,

if you don;t want to enable the audit report, well, that is fine. A pity, because it would give that information to you on need an automated basis.

You can get that information on IT standard ways. of course, it has an impact on time, or budget, or even performance of your system (therefore those times can be incremented).

Some ways I can imagine:

- there are tools on the market for web stressing and tests. You can give them a try.

- You can do this manually, with the web developer tools implemented now on any web browser.

- You can extend the logs of your web applications, from to INFO or even DEBUG, but this will increment the size of your logs (a lot), therefore also your web applications might become slow, plus on some security models this is absolutely not allowed on Production environments.

- You can use jmeter and similar tools, you will need an expert to use something like that.

[JuanS_OCS]

For whomever lands in this question, I recommend, highly, to read this great paper:

http://support.sas.com/resources/papers/proceedings17/SAS0734-2017.pdf

Designing for Performance – Best Practices for SAS® Visual Analytics Reports

[SASKiwi]

To get some very helpful timings on SAS VA reports, open the report in Report Designer and then press the CNTRL, ALT and P keys simultaneously. This should bring up a window listing the timings for both the rendering of report objects and also the data queries underlying them. I see this is mentioned in the paper @JuanS_OCS references.