[6.1] Performance Tuning for 6.1/Progress

Yahoo Archive
1
Thanks Bill...YahooGroup does not allow attachments. Please send to caugheyt@...<mailto:caugheyt@...> .

Also the tip on the client side jogged a memory. I have one client I converted early that takes a good 10 minutes to get a login screen. I'll bet there is registry junk at work.

-Todd C.

________________________________
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of William Hannah
Sent: Wednesday, November 21, 2007 12:38 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] [6.1] Performance Tuning for 6.1/Progress


Todd,

We recently moved our 6.1 install to a new server and I received the
attached documents from support to assist with optimizing the database
and slow logins. Logins from launch to login screen were approx 45
seconds.

As I heard at perspectives from Ben Nixon, "Each site is different!", so
there isn't necessarily a stock answer to how to configure it. I would
go through the guide and then test as much as you can. If you have to
change something, do one thing at a time, because it may take some time
to figure out the right parameter to change to help in your situation.
I was very frustrated for about a week before I was able to get the
performance to an acceptable level.

I noticed that when we changed, some of the client machines had
difficulty with Vantage not cleaning up after itself IF I could get it
to uninstall from the old server. I finally had to search the registry
to clean out any reference to the old Vantage server to improve the
performance. I also created the local cache files for the schema and
forced the registration of the ActiveX components to improve
performance. Logins on the new clients are now approx 7 secs.

Best regards,

Bill

William Hannah
Director of Finance
William Frick & Company
Phone: 847-918-7338
william.hannah@...<mailto:william.hannah%40fricknet.com>


________________________________

From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf
Of Todd Caughey
Sent: Wednesday, November 21, 2007 11:30 AM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
Subject: [Vantage] [6.1] Performance Tuning for 6.1/Progress

I'm moving Vantage 6.1 to a new server this long weekend. Much more
powerful than the 7 year-old server we've had. I would like to take
advantage of the added resources...especially the increase from 1GB RAM
to 8GB, the 8 CPU cores and much faster disks. Once upon a time there
was a performance tuning guide for 6.1 on Progress DB on the FTP site
but I can't find it on EpicWeb. Anyone know if this is still available
(and valid)? I'm going to look back through some old Perspectives disks
for sessions on performance tuning but the document I recall had some
specific formulas based on hardware parameters you plug in.

Aside from that any suggestions for settings to best use the new
hardware? The current system has been spending most of the time with
over 50% CPU in kernal mode making me think it has been disk swap
thrashing due to memory constraint. I want to make sure the new RAM gets
used efficiently and load is spread across the processors. Come Monday I
would really like to get as much "WOW factor" from the users as
possible.

Thanks,
Todd Caughey
Harvey Vogel Mfg. Co,

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]





[Non-text portions of this message have been removed]
2
I'm moving Vantage 6.1 to a new server this long weekend. Much more powerful than the 7 year-old server we've had. I would like to take advantage of the added resources...especially the increase from 1GB RAM to 8GB, the 8 CPU cores and much faster disks. Once upon a time there was a performance tuning guide for 6.1 on Progress DB on the FTP site but I can't find it on EpicWeb. Anyone know if this is still available (and valid)? I'm going to look back through some old Perspectives disks for sessions on performance tuning but the document I recall had some specific formulas based on hardware parameters you plug in.

Aside from that any suggestions for settings to best use the new hardware? The current system has been spending most of the time with over 50% CPU in kernal mode making me think it has been disk swap thrashing due to memory constraint. I want to make sure the new RAM gets used efficiently and load is spread across the processors. Come Monday I would really like to get as much "WOW factor" from the users as possible.

Thanks,
Todd Caughey
Harvey Vogel Mfg. Co,


[Non-text portions of this message have been removed]
3
FYI...My thanks to Michael Barry for an off-list reponse with a document attached from Progress Corp. I also found a posting on the Epicor Vantage Forum for 8.x that I think may apply to 6.1. It looks very similar to the 6.1 document I was looking for. As much as I would like to benchmark each change I will only have time to take my best shot. At the very least getting the spinlocks set right for multiple processors.
-Todd C


[Non-text portions of this message have been removed]
4
Todd,

We recently moved our 6.1 install to a new server and I received the
attached documents from support to assist with optimizing the database
and slow logins. Logins from launch to login screen were approx 45
seconds.

As I heard at perspectives from Ben Nixon, "Each site is different!", so
there isn't necessarily a stock answer to how to configure it. I would
go through the guide and then test as much as you can. If you have to
change something, do one thing at a time, because it may take some time
to figure out the right parameter to change to help in your situation.
I was very frustrated for about a week before I was able to get the
performance to an acceptable level.

I noticed that when we changed, some of the client machines had
difficulty with Vantage not cleaning up after itself IF I could get it
to uninstall from the old server. I finally had to search the registry
to clean out any reference to the old Vantage server to improve the
performance. I also created the local cache files for the schema and
forced the registration of the ActiveX components to improve
performance. Logins on the new clients are now approx 7 secs.

Best regards,

Bill

William Hannah
Director of Finance
William Frick & Company
Phone: 847-918-7338
william.hannah@...


________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Todd Caughey
Sent: Wednesday, November 21, 2007 11:30 AM
To: vantage@yahoogroups.com
Subject: [Vantage] [6.1] Performance Tuning for 6.1/Progress



I'm moving Vantage 6.1 to a new server this long weekend. Much more
powerful than the 7 year-old server we've had. I would like to take
advantage of the added resources...especially the increase from 1GB RAM
to 8GB, the 8 CPU cores and much faster disks. Once upon a time there
was a performance tuning guide for 6.1 on Progress DB on the FTP site
but I can't find it on EpicWeb. Anyone know if this is still available
(and valid)? I'm going to look back through some old Perspectives disks
for sessions on performance tuning but the document I recall had some
specific formulas based on hardware parameters you plug in.

Aside from that any suggestions for settings to best use the new
hardware? The current system has been spending most of the time with
over 50% CPU in kernal mode making me think it has been disk swap
thrashing due to memory constraint. I want to make sure the new RAM gets
used efficiently and load is spread across the processors. Come Monday I
would really like to get as much "WOW factor" from the users as
possible.

Thanks,
Todd Caughey
Harvey Vogel Mfg. Co,

[Non-text portions of this message have been removed]






[Non-text portions of this message have been removed]