John
I talked with tech support. I think it was Dave... he told me every
10000 buffers is roughly equal to about 43 meg of memory. He said that
you should start off with using about 1/3 of your memory for buffer
space, then increase (in increments of 10000) until performance drops
off. He said that you will reach a "plateau", and then performance will
drop off like a "cliff". I got conflicting reports about exactly how
much is the max that progress will use... one tech said that the max
Progress will use is 256 meg, while Dave said the max Progress will use
is 512 Meg.
You need to set the buffers, then let things settle for a few days.
Measurement was difficult. I measured things like how long it took to
pull up a customer in customer tracker who had no invoices or no
invoices in a long time, time to run some long reports... etc. I also
monitored things like "pages-per-sec", and CPU utilization, and found
that when I put the buffers too high, the CPU utilization peged out, and
buffers too low, then "pages-per-second" peged out! Not exactly a
science.
Epicor has a performance tuning document! I also found some
performance tuning (more detailed) on Progress's site.
Britt Moelling
M&M Manufacturing Co.
jkoppes@... wrote:
Britt Moelling
M&M Manufacturing Co.
[Non-text portions of this message have been removed]
I talked with tech support. I think it was Dave... he told me every
10000 buffers is roughly equal to about 43 meg of memory. He said that
you should start off with using about 1/3 of your memory for buffer
space, then increase (in increments of 10000) until performance drops
off. He said that you will reach a "plateau", and then performance will
drop off like a "cliff". I got conflicting reports about exactly how
much is the max that progress will use... one tech said that the max
Progress will use is 256 meg, while Dave said the max Progress will use
is 512 Meg.
You need to set the buffers, then let things settle for a few days.
Measurement was difficult. I measured things like how long it took to
pull up a customer in customer tracker who had no invoices or no
invoices in a long time, time to run some long reports... etc. I also
monitored things like "pages-per-sec", and CPU utilization, and found
that when I put the buffers too high, the CPU utilization peged out, and
buffers too low, then "pages-per-second" peged out! Not exactly a
science.
Epicor has a performance tuning document! I also found some
performance tuning (more detailed) on Progress's site.
Britt Moelling
M&M Manufacturing Co.
jkoppes@... wrote:
>[match.com Search FREE Profiles NOW!]
>
> Britt-
>
> I am interested in the testing process you undertook. What
> increment
> did you increase the buffers and what did you run for the test and how
> did
> you measure performance? I am in the process of spec-ing a new server
> for
> Vantage only use and have 1 GIG set aside for it. Would like to reduce
> the
> cost if I can. Thanks.
>
>
>
> _________________
> John Koppes
> Systems Coordinator
> PRECISION MACHINE AND MANUFACTURING COMPANY
> Address: PO Box 157
> Story City, Iowa 50248
> Phone: (515) 733-5181 Ext. 256
> Fax: (515) 733-4220
>
>
>
>
> >You tell progress how much memory to use in the number of buffers you
>
> >allocate.(-B)
> >Epicor told me that you just have to "try" different buffer sizes,
> and
> >check performance, since each server is different. Too much memory,
> can
> >cause the CPU to become over burdened and adversly affect
> performance.
> >Too little memory allocated will cause the buffers to be flushed too
> >often. In our case, more memory (we have 768 meg) would not do us
> any
> >good, since we are only using about 300meg for buffering. I did tests
>
> >with higher buffer settings, and performance went down.
>
>
>
>
>
>
>
> ______________________________________________________________________
>
> This document should only be read by those persons to whom it is
> addressed and is not intended to be relied upon by any person without
> subsequent written confirmation of its contents. Accordingly,
> PRECISION
> MACHINE AND MANUFACTURING COMPANY disclaims all responsibility and
> accepts
> no liability, including in negligence, for the consequences for any
> person
> acting, or refraining from acting, on such information prior to the
> receipt
> by those persons of subsequent written confirmation.
>
> If you have received this E-mail / Fax message in error, please
> notify
> PRECISION MACHINE AND MANUFACTURING COMPANY immediately by telephone.
> Please also destroy and delete the message.
>
> Contact:
> By Phone: Systems Administrator at (515)-733-5181
> By Email: sysadmin@...
>
> Any form of reproduction, dissemination, copying, disclosure,
> modification, distribution and/or publication of this E-mail / Fax
> message
> is strictly prohibited.
>
>
>
> Yahoo! Groups Sponsor
>--
> To access the Files Section of our Yahoo!Group for Report Builder and
> Crystal Reports and other 'goodies', please go to:
> http://groups.yahoo.com/group/vantage/files/. Note: You must have
> already linked your email address to a yahoo id to enable access.
>
> Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
Britt Moelling
M&M Manufacturing Co.
[Non-text portions of this message have been removed]