Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

CE 8.5 - How to empty pending and waiting buckets 1

Status
Not open for further replies.

SCantoria

Programmer
Sep 23, 2005
100
US
In Home/Settings/Metrics under Current jobs, pending is 3230 and waiting 1050. This is causing our schduled reports to run late of not run at all. These pending jobs are not showing on view instances either. Is ther a way to flush out what is on pending?

Thanks,

Steve C.
 
Pending may mean that there's an instance scheduled for next month, it's still pending.

Waiting means that they are in the queue for when the server has time to run them.

I think that your concern is that you don't have sufficient resources to run all of the waiting reports.

-k
 
So the all the recurring instances are what I am seeing in the pending bucket and the waiting is what really needs to run now.

What resources would I need to start looking at? in task manager/performance tab, commit charge limit is 4035848 and it only peaked at 997948 and I have 6GB of free space in the C: drive.

Thanks,

Steve C.
 
There are limits that can be set to the number of simulataneous reports that can be run, that might help.

It's been quite some time since I ran CE 8.5, but I think it's under the job server.

-k
 
I was looking at the JOB server too and it is set to 5 maximum jobs allowed. Does this sound correct?
 
Sounds low to me, but it's dependent upon the hardware, database and complexity of the reports.

Try pumping it up to 10 and see if the server chokes...

There may be another setting on the page server or one of the other servers as well.

-k
 
5 concurrent jobs is the default (and recommended maximum) per CPU.

Bob Suruncle
 
Bob is correct in that it is the "recommended maximum per CPU" but as SV states it is much more relevant to understand the H/W, CE architecture distribution, and report compexity.

5 concurrent jobs is very conservative IMO. e.g. it's always been 5 even though CPUs are much more powerful now than five (six?) years ago when v8 came out. (and it was a conservative recommendation then).

Also Page Server is not going to have any impact on waiting jobs.

Kingfisher
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top