Performance Tuning for Burst Reporting

[davill]

Hi All,

we have a Crystal Server 2011 Platform on which run a lot of effective reports during the day.

Recently we have purchased additional license to run Burst Reporting for about 10.000 different dynamic destinations.

The problem is that while the burst reporting is executing (about 2 hours) no other report can be run resulting in all the requests going in the pending status.

Is there an official documentation to perform some tuning on the service in order to allow other reports to run while executing burst reporting?

Thanks in advance.

[davill]

We have found an useful document on http://scn.sap.com/docs/DOC-33183

Try to read and understand it

[Former Member]

Please check the below url

http://scn.sap.com/people/ashish.bamzai/blog/2012/03/08/performance-tuning-using-report-bursting-ind...

[former_member136842]

Hi,

looks like that you would need more available connections in your connection pool. You can do this by increasing the connections on the existing CR Services or add more CR Services. If your HW can handle it i would recommend adding more CR Services.

Regards

-Seb.

[davill]

Thanks for your answer but this is not a matter of performance but concurrency. I made the optimization on index bursting in the past improving the time to run the report but a big amount of files to create require always a lot of time. My concern is about to allow the execution of other reports while running the long running burst report.

[davill]

I'll try your advice. We have a server with 16 core and 16 Gigabyte. I suppose the hardware is good enough to handle this.

[Former Member]

If that is the case, Try to increase your Crystal services to handle the load

[denis_konovalov]

You never know if it is enough unless you do proper sizing exercise.

[davill]

Created 4 copies of AdaptiveJobServer but the problem is still in place.

I would like to know which service has exausthed the pool in order to create enough copies of it.

Should I have to monitor something else?

[Former Member]

Try to increase your Crystal services to process your requests. CR processing services.