What is the suggested Hardwarelayout?

[cenbells]

Hi Folks,

I was asked to give advice to the question how to improve the performance of a Jasperserver w/ JasperAnalysis Installation because the response times are quite high during business hours.

Current situation is as follows: One Machine hosting  DBMS (oracle) with aggregated data for OLAP, and running tomcat with JS deployed into. The JS is configured to store its metadata (reports, connections, users) in the same db. The Oracle DB is configured to have multiple Tablespaces distributed over several harddrives using partitioning of tables where necessary and bitmap indexes and such to improve DB performance where possible. Total size of DB is around 500GB right now.

As mentioned before, the response times of JasperServer (not speaking of Analysis parts right now) are quite high during business hours and therefore one asked how performance can be increased efficiently.

First possibility that crossed my mind is, split App and DWH DB. So, setup a new machine with tomcat and move jasperserver installation to it. Eventually move Jasperserver Metadata DB to new AppServer as well.  This should be sufficient to increase JasperServer response times. What do you think?

If the above solution is advisable another question towards this would be the size of the Hardware running tomcat with Jasperserver. 2 Dual core processors, 16GB memory, and some 100 GB of HD? Is this enough ram or would you go for more. (I know more is mostly better, but it should be reasonable). And yes, machine would be running 64bit OS and Java. Memory allocation should be possible with it.

If there is any other possibility to really improve performance feel free to post here.

Thanks in advance for all your valuable comments.

Kind REgards,

CenBells

 

[swood]

Where do you think the bottleneck in performance is? It is mostly likely to be related to the report queries, ie. Oracle performance. The repository is generally pretty small compared to the data you are reporting off, but if you have a lot of reports, folders, saved content from scheduled reporting etc.

Is the speed issue with lots of reports being run simultaneously? What number of users are running when you have performance issues? Are you running out of memory? Are the reports large (numbers of pages, MB)?

In terms of hardware specs for JasperServer, you should have plenty of headroom with what you outline.

When running reports, each report consumes a limited amount of Java heap, and then uses the Java temp directory as a cache for report content using the JasperReports virtualizer. We have seen some issues with local disk speed when you are doing a lot of simultaneous reports.

Another thing to watch for is the allocated number of Tomcat threads and JDBC report data source connections. If more users are active than threads or connections, the server will queue up requests until resources become available. These can be upped.

 

Sherman

Jaspersoft

[sendarnav]

Hi Sherman,

The Jasper server is getting hanged when running a big  report, 1 report is consuming almost 3GB of memory, wondering why Jasper server is taking almost 3 GB for 1 report even if the query is very slow. I don't mind if it takes more time to generate big reports, but memory consumption should be reasonable.

Any help is really appreciated

[ifr_jmb]

Hi

I have the same problem  running a big  report, one report is consuming almost 3GB of memory.

The professionnal support have no answers...

Ad hoc report looks very good since 4.5. But ad hoc report don't seem ready for production for professionnal with large data sets.(it's just ok for demo data)

swood, do you think ad hoc performance will be better with next release

 

jm