Background Que

Chris Kelleher

Administrator
Staff member
I am running SL2g01 on NT4. I have started to get the users to send jobs to
the background que to free up their pc's. Since I started this, it has
almost brought my server down to its knees.

Is anyone else experiencing this - is this typical of the background que?

Thanks
Jeani
 
On NT, unless you have a really big Multi-Processor machine
with oodles and oodles of memory, you shouldn't be
running the background queue on the same machine as
the db server, because it can significantly impact
your performance, as you have seen. Basically you have
moved a significant portion of the load from multiple
client PC's to a single box.

Patrick T. Gordon
Senior Software Engineer
Software Services
Symix Computer Systems, Inc.
Columbus, OH 43231
Phone: 614/523-7000
Fax: 614/895-1195
 
This deserves some clarification. The background queue is simply a Progress
process (prowin32 on NT) which runs programs in batch mode. Since it's
single-threaded, if you run a fairly processor-intensive program, you can
completely bury one of your processors. Since by default it uses a *run.pf
file to start, its memory requirements are no different from your other
clients. In other words, processor time is probably more of a concern than
memory, since it won't haphazardly consume memory on the server.

If you use the background queue to schedule after-hours jobs--as most of our
clients do--then its impact on your server will be minimal. If your
end-users schedule jobs to run throughout the work day, then yes, you'll be
tying up one of your processors completely. I'd say you're left with two
choices at that point: Either strongly suggest that your users schedule
jobs after-hours, or move your background queue to another system.

Probably worth mentioning at this point is AppServer . . . but I don't have
the time! :-)

Regards,
--Fred Pullen
frpul@logicdata.com
 
Unless of course your server is already underpowered
in which case, adding the prowin32 can initiate swapping.
A single session can take dozens of mB of memory.
 
Back
Top