topic Re: Nprinting capacity in Qlik NPrinting

Nprinting capacity

sujeet_shirude — Wed, 25 Sep 2019 18:40:54 GMT

Hi All,

Based on the standard system specifications listed below the questions, do we know:

1. How may reports can be included and run as a single Nprinting task?

2. Does the total page number of all the reports included and run as a single NPrinting task impact successful distribution to intended recipients?

3. If there is a page number limitation, what is this number?

System Specifications

Windows Server 2012 or Windows Server 2012 R2
Microsoft .Net Framework 4.5.2 or above
8 gigabytes of RAM for NPrinting Server
500 MB of disk space for NPrinting Server
Minimum of 2 GB is required for each core with the minimum of 4GB of RAM in total for NPrinting Engine
300 MB of disk space for NPrinting Engine
Qlik Sense Server 2.2.4 or higher to create connections to Qlik Sense
Qlik Sense Server 3.0.1 or higher to distribute reports to the Qlik Sense hub
Qlik Sense generated QlikClient certificate, server certificate, and root certificate
NPrinting Console supports Internet Explorer 10 or above, Chrome, Firefox, and Edge

Thank you,

Sujeet Shirude

Re: Nprinting capacity

woutermak — Thu, 23 Mar 2017 08:12:17 GMT

Hi,

This depends of:

The amount of data in the Qlik app.

The number of levels are used in a report.

The number of connections are used.

The amount of data you want to display in your report.

The number of reports you want to send via a task

The number of users connected to a task.

Unfortunately not a clear answer. For as far as I know is there not a limit of pages for a report.

I just would try it and test it.
Wouter

Re: Nprinting capacity

ogster1974 — Thu, 23 Mar 2017 18:07:38 GMT

My experience is I started with

4gb ram

2 cores

Tried to run a basic report and it took 40mins if it ran at all.

Upgraded to

8gb

4 cores

Tried same report and it took 2mins to generate combined with release of 17.3

Having Levels really effects performance at the moment.

Currently upgrading box to

16gb

8 cores

Will see how it goes. I need to get it under a couple of seconds per report published to a user to be production ready from a performance point of view.

Re: Nprinting capacity

Thu, 23 Mar 2017 18:44:51 GMT

A very important consideration when sizing an NPrinting system is the following:

Each available core will increase RAM requirements geometrically. 4 cores will consume twice the RAM as 2 cores.

Also, they type of connection you make will have a big impact on RAM consumption. "Local" connections to QWVs will open an instance of the QVW on the local machine for every core. Server connections and connections to Sense apps will consume much less RAM.

Re: Nprinting capacity

ogster1974 — Thu, 23 Mar 2017 19:36:36 GMT

As an update the Ram update we went to 16 from 4 and this time it's 32.

We are using sense apps from a separate server and found the RAM consumption was fine it was the cores that were being used heavily.

I've been suggested this config as a good start point but obviously that's not what the minimum requirements say and bench marking data is just not available at the moment. hopefully this kind of work will help others.

Re: Nprinting capacity

sujeet_shirude — Mon, 27 Mar 2017 14:15:29 GMT

Thanks, Wouter!

Re: Nprinting capacity

sujeet_shirude — Mon, 27 Mar 2017 14:22:57 GMT

Thank, Andy!

We upgraded from 4 CPUs to 8 and noticed a performance improvement. Now the report group Task completes in around 15mins where as earlier it was uncertain.

Re: Nprinting capacity

sujeet_shirude — Mon, 27 Mar 2017 14:24:12 GMT

Thanks Aran!

We upgraded from 4 CPUs to 8 and noticed a performance improvement. Now the report group Task completes in around 15mins where as earlier it was uncertain.

Re: Nprinting capacity

ogster1974 — Mon, 27 Mar 2017 14:32:42 GMT

Adding cores makes a difference I think QLik should be more realistic with its minimum requirements. 8 seems to be a number where reasonable sized reports start to publish even if the speed could still be better.

Re: Nprinting capacity

Stephen_Jasionowski — Mon, 27 Mar 2017 15:34:13 GMT

We are working on a whitepaper to help determine requirements based on number of reports, complexity and other factors. That will help guide customers and partners for the minimum hardware needed for their deployments.

Re: Nprinting capacity

Danijel — Thu, 18 May 2017 14:07:49 GMT

sjw‌ Is the white paper already available?

Re: Nprinting capacity

nvankorlaar — Tue, 20 Jun 2017 12:39:25 GMT

Hi, what is the status of this whitepaper?
It was also mentioned in last Tech Thursdays, but still have not seen it.

Re: Nprinting capacity

Stephen_Jasionowski — Tue, 20 Jun 2017 16:58:18 GMT

The whitepaper is now available

Re: Nprinting capacity

Troy1 — Mon, 16 Apr 2018 12:49:09 GMT

Hi Everyone

We have cluster environment and currently run NPrint jobs from QDS machine with server connection.

Are these virtual servers? do physical works better (as in case with QVS requirement)
going above 16 cores, is there any big advantage?
16cores will require 32 gb? does CPU speed have big impact or memory speed?
large number of users connecting to NewsStand, how much extra RAM does it consume.
many ON-Demand report runs how much extra Ram does it consume.
any other findings for optimization.