Tool for easy creation of load/performance tests of QlikView (v.10 and 11)

[Jens_Argentzell]

Document replaced by QV Scalability Tools (QV10,QV11)

[#2]

Problems solved. The end of the script tries to save qvd files

     Store MeterLogs into Submit2SC/$(vFolder).JMeterLogs.qvd (qvd);

Problems was no folder Submit2SC

[Sebastian_Fredenberg]

Hi,

No I believe a CAL should to be consumed, if the environment is setup in that way and the tool simulates proper logins. That can be checked by looking att opened sessions in the management console for example, or in the logs.  

[#4]

Hi Sebastian,

Yes, we have cals assigned to each login that is simulated.

One more question regarding the log results - I have genrated the SC_Results qvw file for the JMeter executions with 25 scripts/JMeter instances and 2 users in each instance (total 50 users). I made sure I have enabled the performance counters and have copied the performance logs from QVTEST01_Processes<Date>.csv
in C:\PerfLogs\Admin\New Data Collector Set\New Data Collector Set  to
ServerLogs-folder  before generating qvds and SC_results file, we have CPU usage data but RAM usage data is missing. There is no data in the graph for viewing 'RAM per click'.  Do you have any suggestions?

[lse]

Hi,

the way the analyzer works is by connecting rows in a test to rows from the Data Collector Sets (Performance Counters) by two parameters: timestamp and machine name.

There is no way to calculate RAM per Click if these two parameters do not match. This is not ideal but we can't control the content of these logs so we have to try to adapt.

If charts, presented in relative time counting from the start of a test, are not showing CPU or RAM then one or both of the above are not matching.

Performance Counters are collected with the local time on the machine but JMeter is collected in milliseconds since 1970, a unix-time stamp. To ensure that the time can be aligned the QVD Generator will use the value in vTimeZone to "move" the JMeter timestamp to align with the local time.

Next thing is to ensure that the name of the QVS in the input field in the QVD Generator is the same as the machine name from the Performance Counter-log. The initial value for this is extracted from the server name that was entered into the URL field in the Scalability Tool. If this was a domain name or ip number then there is no way for the Analyzer to link the two data sets. Based on the name of the csv-file the problem seems to be time.

There is unfortunately one other issue that is harder to correct and that is if the Performance Counter-files you have was started before QlikView was installed. The xml-template we provide will log CPU and RAM for any running processes found when it is started. Even if you start them before running the JMeter test, windows will not collect any data for the "newly" started processes. Open the csv file and search for the word "qvs" to ensure that you have collected data for the processes needed.

One way to validate if the time alignment is correct is to view the PrintSheet, CalendarTime to see if you see any trace of CPU or RAM. If it is there and you can validate that the amount of RAM in the beginning of the test correlate with what you expect then you know that the time stamps are aligned. If both server name and time stamps align then you should see CPU and RAM in the PrintSheet, Relative time.

The analyzer is actually reading in the Performance Counters in three tables in the data model: with time only as the key, with time and webserver and with time an qlikviewserver. Only records within the timespan of the actual test plus a buffer will be used.

Good luck!

/lars

[jeremy_fourman]

Hello and thank you for this!

I am encountering a couple issues:

1. When I reload SC_Results - [application name]. I receive Field not found - <LogFileShortName> when trying to read from JMeterLogMeta.csv

2. No Data to Display on 'RAM per click'

I was able to get around 1 above by modifying the mapping load of TestGroup and TestServer tables to use utf8 in place of 'codepage is 1252'.

(txt, codepage is 1252, embedded labels, delimiter is ';', msq) became (txt, utf8, embedded labels, delimiter is ';', msq).

I did this because loading the spreadsheet directly in QV that is the string it defined for me, is this bad? I noticed though that codepage 1252 is in multiple places, which leads me to believe it is needed. I'm sure you guys know what is needed more than I do!

I am unsure on #2 but I believe they are interrelated?

I am building a POC of this working on my laptop so my current test environment is.

Win 7 64b

QV 11.2 SR4

16G RAM

Will gladly provide more info if needed, thanks for any help offered!

-Jeremy

[Alejandro_Hernández]

Regarding #2..

1. If you are not using IIS, make sure that first cyclic dimension does not have it selected.

if that doesn't work..

2. In QVD Generator.qvw verify TestServerName field is correct when creating Meta-CSV file.

[jeremy_fourman]

Aaah, I did not see the second page of comments. Parsing Lars' comment now, will post back if issues. Thanks again.

[jeremy_fourman]

Thank you Alejandro but embarrassingly my #2 was not setting my timezone correctly but that does not seem to have an affect on Field not found - <LogFileShortName>.

Thanks for the advice,it is good to know!

[valerio_fatatis]

This is a very beautifull program wonderfull

[koresaket]

I need to use the tool for performing load testing. However. is this package only compatible with 64 bit client systems? Is there a 32 bit version of the same? Thanks.