On 10.2.1 FP4 , when I run 2 different jobs.. the 1st job goes into 'Executing' status and the 2nd job goes into 'PENDING' status
Is there a tuning parameter that determines how many jobs/reports I can run simultaneously at one time?
Thanks
Quote from: bud659 on 18 Aug 2014 04:01:55 PM
On 10.2.1 FP4 , when I run 2 different jobs.. the 1st job goes into 'Executing' status and the 2nd job goes into 'PENDING' status
Is there a tuning parameter that determines how many jobs/reports I can run simultaneously at one time?
Thanks
How many reports does the first job trigger? How many batch report services are configured in your instance, and how many connections? The maximum number of simultaneous reports that can be run is the multiple of these two values. I'm guessing your first job has enough reports to use up all of the available connections on all the batch report services, so the rest (including the reports for the second job) will queue until resources are freed up to process them.
Cheers!
MF.
The first job has 11 reports and the second job has 3 reports.
Batch report services : Number of configured processes = 9.
I couldn't find any Connection settings. where are they?
And if I understand correctly, If I want to control how many reports/jobs are run at the same time, its these 2 settings that control that? Now if I can only find connections
Cheers
Quote from: bud659 on 19 Aug 2014 08:17:50 AM
The first job has 11 reports and the second job has 3 reports.
Batch report services : Number of configured processes = 9.
I couldn't find any Connection settings. where are they?
And if I understand correctly, If I want to control how many reports/jobs are run at the same time, its these 2 settings that control that? Now if I can only find connections
Cheers
Hi,
In the Admin Console, go to Configuration > Dispatchers and Services and go into the properties of the Batch Report Service entry. On the Settings tab, select "Tuning" frop the dropdown and you will see things like:
Number of high affinity connections for the batch report service during non-peak period
Number of low affinity connections for the batch report service during non-peak period
Maximum number of processes for the batch report service during non-peak period
Number of high affinity connections for the batch report service during peak period
Number of low affinity connections for the batch report service during peak period
Maximum number of processes for the batch report service during peak period
Cheers!
MF.
Hi MFGF,
So you mean number of interactive reports that can be run simultaneously = Maximum number processes for the Interactive report service * number of connections
for ex : Maximum number processes for the Interactive report service = 2 * # of CPUs ( lets consider we are using 2 cpus) = 4
Number of low affinity connections for the Interactive report service = for each BIBUS process 2 (in our ex number of BIBUS =2 * # of CPUs = 2 * 2 = 4 ) 2 * 4 = 8 connections
8
So maximum number of interactive reports that can be run in this case is = 4 * 8 = 32 reports.
If I have another dispatcher then number of interactive reports would double to 64 ?
Is this calculation is correct ?
Quote from: cognoslearner1 on 24 Aug 2014 10:58:40 AM
Hi MFGF,
So you mean number of interactive reports that can be run simultaneously = Maximum number processes for the Interactive report service * number of connections
for ex : Maximum number processes for the Interactive report service = 2 * # of CPUs ( lets consider we are using 2 cpus) = 4
Number of low affinity connections for the Interactive report service = for each BIBUS process 2 (in our ex number of BIBUS =2 * # of CPUs = 2 * 2 = 4 ) 2 * 4 = 8 connections
8
So maximum number of interactive reports that can be run in this case is = 4 * 8 = 32 reports.
If I have another dispatcher then number of interactive reports would double to 64 ?
Is this calculation is correct ?
No. Not interactive reports. These are reports that are run "live" in a user's browser session.
You need to took at the properties of the batch report service, not the interactive report service. Look at the maximum number of processes and multiply this by the number of connections.
Cheers!
MF.