Vantage Performance - Email found in subject

Yes - attached is the dump & load document we used. I'm still looking
for another one for performance tuning - maybe somebody else knows. That
part is a bit more complicated, and the support person we worked with at
the time had recommended different than the document suggested.



We did not archive any transactions - we still have everything going
back to 2003 in the live db except for change logs which we purged
before final conversion. The change logs were huge and caused the
conversion to run very long.



Randy



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Lori Gustafson
Sent: Tuesday, February 23, 2010 10:32 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Vantage Performance - Email found in subject





Randy,

How did you do the dump and load? Is there documentation somewhere that
explains how to do this? We are planning on upgrading to 8.03.xx
sometime this year but we are not quite there yet. Any performance
enhancements will help. Also, do you know if there is a way to archive
old transactions?

Thanks,

Lori Gustafson

Information Resources

Precision, Inc.

763-852-6718

________________________________

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Randy Weber
Sent: Tuesday, February 23, 2010 10:21 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Vantage Performance - Email found in subject

Lori,

We also have a progress db on a similar HP server configuration. 22 full
licenses and 8 MES.

We upgraded from 6.1 to 8.0x about a year ago and had several
performance issues. After we did a dump and load things improved
significantly but we still had issues. One major issue that comes to
mind was when searching for a customer in order entry, the wait time was
several minutes. This turned out to be a bug that was fixed in 8.03x.
Since we went to 8.03 we have not had any performance issues. I highly
recommend moving up to at least 8.03C. There were several thousand bug
fixes between 8.0x and 8.03x !

Randy Weber

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Lori Gustafson
Sent: Tuesday, February 23, 2010 8:27 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Vantage Performance

We are running Vantage 8.00.811b on a Progress DB and are having issues
with performance being really slow at times. I have started and stopped
the db and app servers and even rebooted the server a few times hoping
it would help but it doesn't seem to make a difference. Does anyone
have any ideas on what would be causing this or any solutions on how to
speed up the performance.

The server is an HP Proliant DL360 G3 Xeon-2.8G with 2GB of DDR RAM
Windows Server 2003.

Regards,

Lori Gustafson

Information Resources

Precision, Inc.

763-852-6718

[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]





[Non-text portions of this message have been removed]
We are running Vantage 8.00.811b on a Progress DB and are having issues
with performance being really slow at times. I have started and stopped
the db and app servers and even rebooted the server a few times hoping
it would help but it doesn't seem to make a difference. Does anyone
have any ideas on what would be causing this or any solutions on how to
speed up the performance.

The server is an HP Proliant DL360 G3 Xeon-2.8G with 2GB of DDR RAM
Windows Server 2003.



Regards,



Lori Gustafson

Information Resources

Precision, Inc.

763-852-6718





[Non-text portions of this message have been removed]
How big is your database?



Thanks,

Blake Clemens

IT Systems Engineer

Delmarva Millwork Corporation

(800) 360-2364 x132

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Lori Gustafson
Sent: Tuesday, February 23, 2010 9:27 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Vantage Performance





We are running Vantage 8.00.811b on a Progress DB and are having issues
with performance being really slow at times. I have started and stopped
the db and app servers and even rebooted the server a few times hoping
it would help but it doesn't seem to make a difference. Does anyone
have any ideas on what would be causing this or any solutions on how to
speed up the performance.

The server is an HP Proliant DL360 G3 Xeon-2.8G with 2GB of DDR RAM
Windows Server 2003.

Regards,

Lori Gustafson

Information Resources

Precision, Inc.

763-852-6718

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



No virus found in this incoming message.
Checked by AVG - www.avg.com
Version: 9.0.733 / Virus Database: 271.1.1/2704 - Release Date: 02/23/10
02:34:00



[Non-text portions of this message have been removed]
It's 1 GB and growing.



Regards,



Lori Gustafson

Information Resources

Precision, Inc.

763-852-6718

________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Blake Clemens
Sent: Tuesday, February 23, 2010 8:28 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Vantage Performance - Email found in subject





How big is your database?

Thanks,

Blake Clemens

IT Systems Engineer

Delmarva Millwork Corporation

(800) 360-2364 x132

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Lori Gustafson
Sent: Tuesday, February 23, 2010 9:27 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Vantage Performance

We are running Vantage 8.00.811b on a Progress DB and are having issues
with performance being really slow at times. I have started and stopped
the db and app servers and even rebooted the server a few times hoping
it would help but it doesn't seem to make a difference. Does anyone
have any ideas on what would be causing this or any solutions on how to
speed up the performance.

The server is an HP Proliant DL360 G3 Xeon-2.8G with 2GB of DDR RAM
Windows Server 2003.

Regards,

Lori Gustafson

Information Resources

Precision, Inc.

763-852-6718

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

No virus found in this incoming message.
Checked by AVG - www.avg.com
Version: 9.0.733 / Virus Database: 271.1.1/2704 - Release Date: 02/23/10
02:34:00

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





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



We also have a progress db on a similar HP server configuration. 22 full
licenses and 8 MES.



We upgraded from 6.1 to 8.0x about a year ago and had several
performance issues. After we did a dump and load things improved
significantly but we still had issues. One major issue that comes to
mind was when searching for a customer in order entry, the wait time was
several minutes. This turned out to be a bug that was fixed in 8.03x.
Since we went to 8.03 we have not had any performance issues. I highly
recommend moving up to at least 8.03C. There were several thousand bug
fixes between 8.0x and 8.03x !



Randy Weber







From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Lori Gustafson
Sent: Tuesday, February 23, 2010 8:27 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Vantage Performance





We are running Vantage 8.00.811b on a Progress DB and are having issues
with performance being really slow at times. I have started and stopped
the db and app servers and even rebooted the server a few times hoping
it would help but it doesn't seem to make a difference. Does anyone
have any ideas on what would be causing this or any solutions on how to
speed up the performance.

The server is an HP Proliant DL360 G3 Xeon-2.8G with 2GB of DDR RAM
Windows Server 2003.

Regards,

Lori Gustafson

Information Resources

Precision, Inc.

763-852-6718

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





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



How did you do the dump and load? Is there documentation somewhere that
explains how to do this? We are planning on upgrading to 8.03.xx
sometime this year but we are not quite there yet. Any performance
enhancements will help. Also, do you know if there is a way to archive
old transactions?



Thanks,





Lori Gustafson

Information Resources

Precision, Inc.

763-852-6718

________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Randy Weber
Sent: Tuesday, February 23, 2010 10:21 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Vantage Performance - Email found in subject





Lori,

We also have a progress db on a similar HP server configuration. 22 full
licenses and 8 MES.

We upgraded from 6.1 to 8.0x about a year ago and had several
performance issues. After we did a dump and load things improved
significantly but we still had issues. One major issue that comes to
mind was when searching for a customer in order entry, the wait time was
several minutes. This turned out to be a bug that was fixed in 8.03x.
Since we went to 8.03 we have not had any performance issues. I highly
recommend moving up to at least 8.03C. There were several thousand bug
fixes between 8.0x and 8.03x !

Randy Weber

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Lori Gustafson
Sent: Tuesday, February 23, 2010 8:27 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Vantage Performance

We are running Vantage 8.00.811b on a Progress DB and are having issues
with performance being really slow at times. I have started and stopped
the db and app servers and even rebooted the server a few times hoping
it would help but it doesn't seem to make a difference. Does anyone
have any ideas on what would be causing this or any solutions on how to
speed up the performance.

The server is an HP Proliant DL360 G3 Xeon-2.8G with 2GB of DDR RAM
Windows Server 2003.

Regards,

Lori Gustafson

Information Resources

Precision, Inc.

763-852-6718

[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]
I uploaded the dump and loaded document to the user group a few months
back. It should still be there.



Thanks,

Blake Clemens

IT Systems Engineer

Delmarva Millwork Corporation

(800) 360-2364 x132

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Lori Gustafson
Sent: Tuesday, February 23, 2010 11:32 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Vantage Performance - Email found in subject





Randy,

How did you do the dump and load? Is there documentation somewhere that
explains how to do this? We are planning on upgrading to 8.03.xx
sometime this year but we are not quite there yet. Any performance
enhancements will help. Also, do you know if there is a way to archive
old transactions?

Thanks,

Lori Gustafson

Information Resources

Precision, Inc.

763-852-6718

________________________________

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Randy Weber
Sent: Tuesday, February 23, 2010 10:21 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Vantage Performance - Email found in subject

Lori,

We also have a progress db on a similar HP server configuration. 22 full
licenses and 8 MES.

We upgraded from 6.1 to 8.0x about a year ago and had several
performance issues. After we did a dump and load things improved
significantly but we still had issues. One major issue that comes to
mind was when searching for a customer in order entry, the wait time was
several minutes. This turned out to be a bug that was fixed in 8.03x.
Since we went to 8.03 we have not had any performance issues. I highly
recommend moving up to at least 8.03C. There were several thousand bug
fixes between 8.0x and 8.03x !

Randy Weber

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Lori Gustafson
Sent: Tuesday, February 23, 2010 8:27 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Vantage Performance

We are running Vantage 8.00.811b on a Progress DB and are having issues
with performance being really slow at times. I have started and stopped
the db and app servers and even rebooted the server a few times hoping
it would help but it doesn't seem to make a difference. Does anyone
have any ideas on what would be causing this or any solutions on how to
speed up the performance.

The server is an HP Proliant DL360 G3 Xeon-2.8G with 2GB of DDR RAM
Windows Server 2003.

Regards,

Lori Gustafson

Information Resources

Precision, Inc.

763-852-6718

[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]



No virus found in this incoming message.
Checked by AVG - www.avg.com
Version: 9.0.733 / Virus Database: 271.1.1/2704 - Release Date: 02/23/10
02:34:00



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