Epicor 9 Performance Issues

Since upgrading to 702, I have not seen any improvements in speed at all. Actually, we are a lot slower on certain processes. Granted, I have not yet had an opportunity to troubleshoot the performance, so hopefully when I do that I will see an improvement.

I recently added another SSD to my Database server, but have not seen much of an improvement from it either. Again, I need to play around with it a little to tweak it and that might get me some improvements, but have not had the chance.

Most of my time since the upgrade has been fixing small issues. For example, edit list not working, trackers not showing invoice numbers, Trial Balance reports not balancing and others.

--- In vantage@yahoogroups.com, "JEFFBOLL" <jeffboll@...> wrote:
>
> Just bought about a dozen SSD's for our PC's. We will see the improvement but the biggest improvement we have noticed is the printing and placing of images. The focus has to be keeping the image size as small as possible - no questions asked. We have out of memory issues because we put our logo on some reports. The logo itself is small 100KB (we had cases where it wasn't) but it was the way we placed the image on the document as well. If you don't do it right it will blow the size of the report out of the water.
>
> --- In vantage@yahoogroups.com, "Joseph" <jcrisino@> wrote:
> >
> > We are also having performance issue since moving to 905.702 but ours seems to be remote plants. is there anybody that has terminal server running for remote sites and has seen an improvement in perforomance?
> >
> > --- In vantage@yahoogroups.com, "mseal" <mseal@> wrote:
> > >
> > > Hi Patrick,
> > > Saw your commend on using SSD on client and servers – I have been using it on clients but holding back on server due to cost.
> > > Is there any way you can quantify the performance gains on the server side when moving from 15K RAID10 to SSD?
> > >
> > > Thanks
> > > Motty
> > >
> > >
> > > --- In vantage@yahoogroups.com, "Winter, Patrick" <pjw@> wrote:
> > > >
> > > > Are you using any clients with SSD's? Having both server and client with SSD's is a wonderful thing.
> > > >
> > > >
> > > >
> > > > Patrick Winter
> > > >
> > > >
> > > >
> > > > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of JEFFBOLL
> > > > Sent: Friday, May 31, 2013 13:21
> > > > To: vantage@yahoogroups.com
> > > > Subject: [Vantage] Re: Epicor 9 Performance Issues
> > > >
> > > >
> > > >
> > > >
> > > >
> > > > Just thought I would tell my story. We are running 9.05.700b with 80 or so users plus an additional 80 MES/handheld devices. We have 4 locations. We are putting in a new server this weekend due to our performance, Epicor has recommended this as we have had them investigate to understand our issues. Our database is only around 8-9 gig but we have poor performance. Our spec for the new server is below and it is as big as we can get to try to conduct business as needed. Seems a bit crazy to me but after going to insights and talking to others i'm not the only one in this boat....
> > > >
> > > > HP DL560P Gen8
> > > > E7-4650 8 core proc, 2.7GHz ( qty 4)
> > > > HP 16gb 2Rx4 PC3-12800R-11 (qty 8)
> > > > HP 200gb 6G SAS SLC 2.1in SC EP SSD (qty 4)
> > > > HP 785gb MLC G2 PCIe IO Accelerator
> > > >
> > > > We are crossing our fingers that this really helps!
> > > >
> > > > --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> , Chris Thompson <chriselectrix@> wrote:
> > > > >
> > > > > Do you regularly restart your apps and db?
> > > > >
> > > > >
> > > > >
> > > > >
> > > > > ________________________________
> > > > > From: mbarryjr1 <mikebarry@>
> > > > > To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > > > > Sent: Saturday, 11 May 2013, 3:35
> > > > > Subject: [Vantage] Re: Epicor 9 Performance Issues
> > > > >
> > > > >
> > > > >
> > > > > Â
> > > > > Hi Ted - did you find a solution? We're seeing the same issue lately.
> > > > >
> > > > > Mike
> > > > >
> > > > > --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> , Ted Koch <tkoch77@> wrote:
> > > > > >
> > > > > > We have recently started seeing sluggishness in Epicor the past couple months as well. We did a dump and load and reindex but it still sometimes takes 5-10 seconds if not longer to open a job in job entry or to save records. Interested too what people are doing/have done to get better performance. Is there a guide Epicor provides that would show how to tweak the database or anything else to get better performance?
> > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > > > > ________________________________
> > > > > > From: supertico05 <mvissuet@>
> > > > > > To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > > > > > Sent: Thursday, April 18, 2013 10:55 AM
> > > > > > Subject: [Vantage] Epicor 9 Performance Issues
> > > > > >
> > > > > >
> > > > > > Recently our Epicor performance went from OK to Horrible.Â
> > > > > > We are currently on 9.05.606, Progress Database.
> > > > > >
> > > > > > MRP used to take about 5 to 6 hours to run, now it takes 15 hours.
> > > > > > Releasing jobs used to take 1 second now takes a minute.
> > > > > > Same for POs.
> > > > > >
> > > > > > We didn't add any BPMs or change any settings.
> > > > > >
> > > > > > Has anyone experienced similar issues and resolved them some how?
> > > > > >
> > > > > > I've heard in the past that if a data table on a progress database reaches 2 million records that it slows down the database... can anyone confirm this?
> > > > > > our change log table is 15 million records. TranGLC is 1.99 million records and GLJrnlGLC is 1.76 million.
> > > > > >
> > > > > >
> > > > > >
> > > > > > ------------------------------------
> > > > > >
> > > > > > Useful links for the Yahoo!Groups Vantage Board are: ( Note:Â You must have already linked your email address to a yahoo id to enable access. )
> > > > > > (1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/. <http://groups.yahoo.com/group/vantage/files/>
> > > > > > (2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
> > > > > > (3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
> > > > > >
> > > > > >
> > > > > >
> > > > > > [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]
> > > >
> > >
> >
>
Recently our Epicor performance went from OK to Horrible.
We are currently on 9.05.606, Progress Database.

MRP used to take about 5 to 6 hours to run, now it takes 15 hours.
Releasing jobs used to take 1 second now takes a minute.
Same for POs.

We didn't add any BPMs or change any settings.

Has anyone experienced similar issues and resolved them some how?

I've heard in the past that if a data table on a progress database reaches 2 million records that it slows down the database... can anyone confirm this?
our change log table is 15 million records. TranGLC is 1.99 million records and GLJrnlGLC is 1.76 million.
Have you enabled replication server?

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of supertico05
Sent: 18 April 2013 15:55
To: vantage@yahoogroups.com
Subject: [Vantage] Epicor 9 Performance Issues



Recently our Epicor performance went from OK to Horrible.
We are currently on 9.05.606, Progress Database.

MRP used to take about 5 to 6 hours to run, now it takes 15 hours.
Releasing jobs used to take 1 second now takes a minute.
Same for POs.

We didn't add any BPMs or change any settings.

Has anyone experienced similar issues and resolved them some how?

I've heard in the past that if a data table on a progress database reaches 2 million records that it slows down the database... can anyone confirm this?
our change log table is 15 million records. TranGLC is 1.99 million records and GLJrnlGLC is 1.76 million.



[Non-text portions of this message have been removed]
We haven't.

How will it help?


Marco Vissuet
Systems Engineer
Pacific Contours Corporation
Cell (619)507-2311
Anaheim Office (714) 693-1260
San Diego Office (619)670-3900
Fax (714) 693-1252
mvissuet@...<mailto:marcov@...>
http://www.pacificcontours.com/

"The information contained herein may be subject to the International Traffic in Arms Regulations (ITAR) Warning: - This document contains data whose export is restricted by the Arms Export Control Act (Title 22, U.S.C., Sec 2751, et seq.) as amended, or the Export Administration Act (Title 50, U.S.C., App 2401 et seq.) as amended. Violations of these export laws are subject to severe criminal and civil penalties. Disseminate in accordance with provisions of DoD Directive 5230.25.

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Stephen Edginton
Sent: Thursday, April 18, 2013 8:22 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Epicor 9 Performance Issues



Have you enabled replication server?

From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf Of supertico05
Sent: 18 April 2013 15:55
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Epicor 9 Performance Issues

Recently our Epicor performance went from OK to Horrible.
We are currently on 9.05.606, Progress Database.

MRP used to take about 5 to 6 hours to run, now it takes 15 hours.
Releasing jobs used to take 1 second now takes a minute.
Same for POs.

We didn't add any BPMs or change any settings.

Has anyone experienced similar issues and resolved them some how?

I've heard in the past that if a data table on a progress database reaches 2 million records that it slows down the database... can anyone confirm this?
our change log table is 15 million records. TranGLC is 1.99 million records and GLJrnlGLC is 1.76 million.

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



[Non-text portions of this message have been removed]
That is good, it is an overhead.

Have you recently performed a dump and load or reindex?

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Marco Vissuet
Sent: 18 April 2013 16:25
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Epicor 9 Performance Issues



We haven't.

How will it help?

Marco Vissuet
Systems Engineer
Pacific Contours Corporation
Cell (619)507-2311
Anaheim Office (714) 693-1260
San Diego Office (619)670-3900
Fax (714) 693-1252
mvissuet@...<mailto:mvissuet%40pacificcontours.com><mailto:marcov@...<mailto:marcov%40pacificcontours.com>>
http://www.pacificcontours.com/

"The information contained herein may be subject to the International Traffic in Arms Regulations (ITAR) Warning: - This document contains data whose export is restricted by the Arms Export Control Act (Title 22, U.S.C., Sec 2751, et seq.) as amended, or the Export Administration Act (Title 50, U.S.C., App 2401 et seq.) as amended. Violations of these export laws are subject to severe criminal and civil penalties. Disseminate in accordance with provisions of DoD Directive 5230.25.

From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf Of Stephen Edginton
Sent: Thursday, April 18, 2013 8:22 AM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Epicor 9 Performance Issues

Have you enabled replication server?

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 supertico05
Sent: 18 April 2013 15:55
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Epicor 9 Performance Issues

Recently our Epicor performance went from OK to Horrible.
We are currently on 9.05.606, Progress Database.

MRP used to take about 5 to 6 hours to run, now it takes 15 hours.
Releasing jobs used to take 1 second now takes a minute.
Same for POs.

We didn't add any BPMs or change any settings.

Has anyone experienced similar issues and resolved them some how?

I've heard in the past that if a data table on a progress database reaches 2 million records that it slows down the database... can anyone confirm this?
our change log table is 15 million records. TranGLC is 1.99 million records and GLJrnlGLC is 1.76 million.

[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 have recently started seeing sluggishness in Epicor the past couple months as well. We did a dump and load and reindex but it still sometimes takes 5-10 seconds if not longer to open a job in job entry or to save records. Interested too what people are doing/have done to get better performance. Is there a guide Epicor provides that would show how to tweak the database or anything else to get better performance?




________________________________
From: supertico05 <mvissuet@...>
To: vantage@yahoogroups.com
Sent: Thursday, April 18, 2013 10:55 AM
Subject: [Vantage] Epicor 9 Performance Issues


Recently our Epicor performance went from OK to Horrible.Â
We are currently on 9.05.606, Progress Database.

MRP used to take about 5 to 6 hours to run, now it takes 15 hours.
Releasing jobs used to take 1 second now takes a minute.
Same for POs.

We didn't add any BPMs or change any settings.

Has anyone experienced similar issues and resolved them some how?

I've heard in the past that if a data table on a progress database reaches 2 million records that it slows down the database... can anyone confirm this?
our change log table is 15 million records. TranGLC is 1.99 million records and GLJrnlGLC is 1.76 million.



------------------------------------

Useful links for the Yahoo!Groups Vantage Board are: ( Note:Â You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links



[Non-text portions of this message have been removed]
We haven't done either one...


Marco Vissuet
Systems Engineer
Pacific Contours Corporation
Cell (619)507-2311
Anaheim Office (714) 693-1260
San Diego Office (619)670-3900
Fax (714) 693-1252
mvissuet@...<mailto:marcov@...>
http://www.pacificcontours.com/

"The information contained herein may be subject to the International Traffic in Arms Regulations (ITAR) Warning: - This document contains data whose export is restricted by the Arms Export Control Act (Title 22, U.S.C., Sec 2751, et seq.) as amended, or the Export Administration Act (Title 50, U.S.C., App 2401 et seq.) as amended. Violations of these export laws are subject to severe criminal and civil penalties. Disseminate in accordance with provisions of DoD Directive 5230.25.

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Stephen Edginton
Sent: Thursday, April 18, 2013 8:27 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Epicor 9 Performance Issues



That is good, it is an overhead.

Have you recently performed a dump and load or reindex?

From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf Of Marco Vissuet
Sent: 18 April 2013 16:25
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Epicor 9 Performance Issues

We haven't.

How will it help?

Marco Vissuet
Systems Engineer
Pacific Contours Corporation
Cell (619)507-2311
Anaheim Office (714) 693-1260
San Diego Office (619)670-3900
Fax (714) 693-1252
mvissuet@...<mailto:mvissuet%40pacificcontours.com><mailto:mvissuet%40pacificcontours.com><mailto:marcov@...<mailto:marcov%40pacificcontours.com><mailto:marcov%40pacificcontours.com>>
http://www.pacificcontours.com/

"The information contained herein may be subject to the International Traffic in Arms Regulations (ITAR) Warning: - This document contains data whose export is restricted by the Arms Export Control Act (Title 22, U.S.C., Sec 2751, et seq.) as amended, or the Export Administration Act (Title 50, U.S.C., App 2401 et seq.) as amended. Violations of these export laws are subject to severe criminal and civil penalties. Disseminate in accordance with provisions of DoD Directive 5230.25.

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 Stephen Edginton
Sent: Thursday, April 18, 2013 8:22 AM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Epicor 9 Performance Issues

Have you enabled replication server?

From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>] On Behalf Of supertico05
Sent: 18 April 2013 15:55
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Epicor 9 Performance Issues

Recently our Epicor performance went from OK to Horrible.
We are currently on 9.05.606, Progress Database.

MRP used to take about 5 to 6 hours to run, now it takes 15 hours.
Releasing jobs used to take 1 second now takes a minute.
Same for POs.

We didn't add any BPMs or change any settings.

Has anyone experienced similar issues and resolved them some how?

I've heard in the past that if a data table on a progress database reaches 2 million records that it slows down the database... can anyone confirm this?
our change log table is 15 million records. TranGLC is 1.99 million records and GLJrnlGLC is 1.76 million.

[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]
When was the last time you did one?

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Marco Vissuet
Sent: 18 April 2013 17:07
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Epicor 9 Performance Issues



We haven't done either one...

Marco Vissuet
Systems Engineer
Pacific Contours Corporation
Cell (619)507-2311
Anaheim Office (714) 693-1260
San Diego Office (619)670-3900
Fax (714) 693-1252
mvissuet@...<mailto:mvissuet%40pacificcontours.com><mailto:marcov@...<mailto:marcov%40pacificcontours.com>>
http://www.pacificcontours.com/

"The information contained herein may be subject to the International Traffic in Arms Regulations (ITAR) Warning: - This document contains data whose export is restricted by the Arms Export Control Act (Title 22, U.S.C., Sec 2751, et seq.) as amended, or the Export Administration Act (Title 50, U.S.C., App 2401 et seq.) as amended. Violations of these export laws are subject to severe criminal and civil penalties. Disseminate in accordance with provisions of DoD Directive 5230.25.

From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf Of Stephen Edginton
Sent: Thursday, April 18, 2013 8:27 AM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Epicor 9 Performance Issues

That is good, it is an overhead.

Have you recently performed a dump and load or reindex?

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 Marco Vissuet
Sent: 18 April 2013 16:25
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Epicor 9 Performance Issues

We haven't.

How will it help?

Marco Vissuet
Systems Engineer
Pacific Contours Corporation
Cell (619)507-2311
Anaheim Office (714) 693-1260
San Diego Office (619)670-3900
Fax (714) 693-1252
mvissuet@...<mailto:mvissuet%40pacificcontours.com><mailto:mvissuet%40pacificcontours.com><mailto:mvissuet%40pacificcontours.com><mailto:marcov@...<mailto:marcov%40pacificcontours.com><mailto:marcov%40pacificcontours.com><mailto:marcov%40pacificcontours.com>>
http://www.pacificcontours.com/

"The information contained herein may be subject to the International Traffic in Arms Regulations (ITAR) Warning: - This document contains data whose export is restricted by the Arms Export Control Act (Title 22, U.S.C., Sec 2751, et seq.) as amended, or the Export Administration Act (Title 50, U.S.C., App 2401 et seq.) as amended. Violations of these export laws are subject to severe criminal and civil penalties. Disseminate in accordance with provisions of DoD Directive 5230.25.

From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>] On Behalf Of Stephen Edginton
Sent: Thursday, April 18, 2013 8:22 AM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Epicor 9 Performance Issues

Have you enabled replication server?

From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>] On Behalf Of supertico05
Sent: 18 April 2013 15:55
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Epicor 9 Performance Issues

Recently our Epicor performance went from OK to Horrible.
We are currently on 9.05.606, Progress Database.

MRP used to take about 5 to 6 hours to run, now it takes 15 hours.
Releasing jobs used to take 1 second now takes a minute.
Same for POs.

We didn't add any BPMs or change any settings.

Has anyone experienced similar issues and resolved them some how?

I've heard in the past that if a data table on a progress database reaches 2 million records that it slows down the database... can anyone confirm this?
our change log table is 15 million records. TranGLC is 1.99 million records and GLJrnlGLC is 1.76 million.

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



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

We have been on Epicor 9.05.606 for a little over a year.
Before that we were on Epicor 9.04 for about 6 months.
Before that Vantage 8 for about a year.


Marco Vissuet
Systems Engineer
Pacific Contours Corporation
Cell (619)507-2311
Anaheim Office (714) 693-1260
San Diego Office (619)670-3900
Fax (714) 693-1252
mvissuet@...<mailto:marcov@...>
http://www.pacificcontours.com/

"The information contained herein may be subject to the International Traffic in Arms Regulations (ITAR) Warning: - This document contains data whose export is restricted by the Arms Export Control Act (Title 22, U.S.C., Sec 2751, et seq.) as amended, or the Export Administration Act (Title 50, U.S.C., App 2401 et seq.) as amended. Violations of these export laws are subject to severe criminal and civil penalties. Disseminate in accordance with provisions of DoD Directive 5230.25.

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Stephen Edginton
Sent: Thursday, April 18, 2013 9:17 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Epicor 9 Performance Issues



When was the last time you did one?

From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf Of Marco Vissuet
Sent: 18 April 2013 17:07
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Epicor 9 Performance Issues

We haven't done either one...

Marco Vissuet
Systems Engineer
Pacific Contours Corporation
Cell (619)507-2311
Anaheim Office (714) 693-1260
San Diego Office (619)670-3900
Fax (714) 693-1252
mvissuet@...<mailto:mvissuet%40pacificcontours.com><mailto:mvissuet%40pacificcontours.com><mailto:marcov@...<mailto:marcov%40pacificcontours.com><mailto:marcov%40pacificcontours.com>>
http://www.pacificcontours.com/

"The information contained herein may be subject to the International Traffic in Arms Regulations (ITAR) Warning: - This document contains data whose export is restricted by the Arms Export Control Act (Title 22, U.S.C., Sec 2751, et seq.) as amended, or the Export Administration Act (Title 50, U.S.C., App 2401 et seq.) as amended. Violations of these export laws are subject to severe criminal and civil penalties. Disseminate in accordance with provisions of DoD Directive 5230.25.

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 Stephen Edginton
Sent: Thursday, April 18, 2013 8:27 AM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Epicor 9 Performance Issues

That is good, it is an overhead.

Have you recently performed a dump and load or reindex?

From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>] On Behalf Of Marco Vissuet
Sent: 18 April 2013 16:25
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Epicor 9 Performance Issues

We haven't.

How will it help?

Marco Vissuet
Systems Engineer
Pacific Contours Corporation
Cell (619)507-2311
Anaheim Office (714) 693-1260
San Diego Office (619)670-3900
Fax (714) 693-1252
mvissuet@...<mailto:mvissuet%40pacificcontours.com><mailto:mvissuet%40pacificcontours.com><mailto:mvissuet%40pacificcontours.com><mailto:mvissuet%40pacificcontours.com><mailto:marcov@...<mailto:marcov%40pacificcontours.com><mailto:marcov%40pacificcontours.com><mailto:marcov%40pacificcontours.com><mailto:marcov%40pacificcontours.com>>
http://www.pacificcontours.com/

"The information contained herein may be subject to the International Traffic in Arms Regulations (ITAR) Warning: - This document contains data whose export is restricted by the Arms Export Control Act (Title 22, U.S.C., Sec 2751, et seq.) as amended, or the Export Administration Act (Title 50, U.S.C., App 2401 et seq.) as amended. Violations of these export laws are subject to severe criminal and civil penalties. Disseminate in accordance with provisions of DoD Directive 5230.25.

From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>] On Behalf Of Stephen Edginton
Sent: Thursday, April 18, 2013 8:22 AM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Epicor 9 Performance Issues

Have you enabled replication server?

From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>] On Behalf Of supertico05
Sent: 18 April 2013 15:55
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Epicor 9 Performance Issues

Recently our Epicor performance went from OK to Horrible.
We are currently on 9.05.606, Progress Database.

MRP used to take about 5 to 6 hours to run, now it takes 15 hours.
Releasing jobs used to take 1 second now takes a minute.
Same for POs.

We didn't add any BPMs or change any settings.

Has anyone experienced similar issues and resolved them some how?

I've heard in the past that if a data table on a progress database reaches 2 million records that it slows down the database... can anyone confirm this?
our change log table is 15 million records. TranGLC is 1.99 million records and GLJrnlGLC is 1.76 million.

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

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



[Non-text portions of this message have been removed]
Good Day Ted:



Version and Progress?



Do you re-boot the servers once a week?

Temp files build up.






Len



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Ted Koch
Sent: Thursday, April 18, 2013 11:39 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Epicor 9 Performance Issues





We have recently started seeing sluggishness in Epicor the past couple
months as well. We did a dump and load and reindex but it still
sometimes takes 5-10 seconds if not longer to open a job in job entry or
to save records. Interested too what people are doing/have done to get
better performance. Is there a guide Epicor provides that would show how
to tweak the database or anything else to get better performance?

________________________________
From: supertico05 <mvissuet@...
<mailto:mvissuet%40pacificcontours.com> >
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Sent: Thursday, April 18, 2013 10:55 AM
Subject: [Vantage] Epicor 9 Performance Issues


Recently our Epicor performance went from OK to Horrible.
We are currently on 9.05.606, Progress Database.

MRP used to take about 5 to 6 hours to run, now it takes 15 hours.
Releasing jobs used to take 1 second now takes a minute.
Same for POs.

We didn't add any BPMs or change any settings.

Has anyone experienced similar issues and resolved them some how?

I've heard in the past that if a data table on a progress database
reaches 2 million records that it slows down the database... can anyone
confirm this?
our change log table is 15 million records. TranGLC is 1.99 million
records and GLJrnlGLC is 1.76 million.

------------------------------------

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links

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





This e-mail and any attachments may contain proprietary and/or confidential information. If you are not the intended recipient, please notify the sender immediately by reply e-mail or at 410-472-2900 and then delete the message without using, disseminating, or copying this message or any portion thereof. With e-mail communications you are urged to protect against viruses.


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

Epicor 9.05.701 Progress.

Currently the server has been up for 26 days. Is it a good idea to restart the entire server weekly?




________________________________
From: Len Hartka <len.hartka@...>
To: vantage@yahoogroups.com
Sent: Thursday, April 18, 2013 1:01 PM
Subject: RE: [Vantage] Epicor 9 Performance Issues


Good Day Ted:



      Version and Progress?



      Do you re-boot the servers once a week?Â

      Temp files build up.

     Â




Len



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Ted Koch
Sent: Thursday, April 18, 2013 11:39 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Epicor 9 Performance Issues



Â

We have recently started seeing sluggishness in Epicor the past couple
months as well. We did a dump and load and reindex but it still
sometimes takes 5-10 seconds if not longer to open a job in job entry or
to save records. Interested too what people are doing/have done to get
better performance. Is there a guide Epicor provides that would show how
to tweak the database or anything else to get better performance?

________________________________
From: supertico05 <mvissuet@...
<mailto:mvissuet%40pacificcontours.com> >
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>Â
Sent: Thursday, April 18, 2013 10:55 AM
Subject: [Vantage] Epicor 9 Performance Issues


Recently our Epicor performance went from OK to Horrible.Â
We are currently on 9.05.606, Progress Database.

MRP used to take about 5 to 6 hours to run, now it takes 15 hours.
Releasing jobs used to take 1 second now takes a minute.
Same for POs.

We didn't add any BPMs or change any settings.

Has anyone experienced similar issues and resolved them some how?

I've heard in the past that if a data table on a progress database
reaches 2 million records that it slows down the database... can anyone
confirm this?
our change log table is 15 million records. TranGLC is 1.99 million
records and GLJrnlGLC is 1.76 million.

------------------------------------

Useful links for the Yahoo!Groups Vantage Board are: ( Note:Â You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links

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





This e-mail and any attachments may contain proprietary and/or confidential information. If you are not the intended recipient, please notify the sender immediately by reply e-mail or at 410-472-2900 and then delete the message without using, disseminating, or copying this message or any portion thereof. With e-mail communications you are urged to protect against viruses.


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



------------------------------------

Useful links for the Yahoo!Groups Vantage Board are: ( Note:Â You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links



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



Unfortunately, yes. It is a good idea to reboot once a week. Before we
went to Epicor 9, we came off a Unix system using a Progress database
(yeah it was an old system), but we didn't reboot for about 6 months.
With Epicor 9, we need to reboot weekly and I've heard from Epicor
support staff also the recommendation to reboot weekly since temp files
build up, and have a fresh restart of the app servers.



Regards,

Sigfredo.



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Ted Koch
Sent: Thursday, April 18, 2013 1:19 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Epicor 9 Performance Issues





Hi Len,

Epicor 9.05.701 Progress.

Currently the server has been up for 26 days. Is it a good idea to
restart the entire server weekly?

________________________________
From: Len Hartka <len.hartka@...
<mailto:len.hartka%40sunautomation.com> >
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Sent: Thursday, April 18, 2013 1:01 PM
Subject: RE: [Vantage] Epicor 9 Performance Issues


Good Day Ted:

Version and Progress?

Do you re-boot the servers once a week?

Temp files build up.



Len

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Ted Koch
Sent: Thursday, April 18, 2013 11:39 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: Re: [Vantage] Epicor 9 Performance Issues



We have recently started seeing sluggishness in Epicor the past couple
months as well. We did a dump and load and reindex but it still
sometimes takes 5-10 seconds if not longer to open a job in job entry or
to save records. Interested too what people are doing/have done to get
better performance. Is there a guide Epicor provides that would show how
to tweak the database or anything else to get better performance?

________________________________
From: supertico05 <mvissuet@...
<mailto:mvissuet%40pacificcontours.com>
<mailto:mvissuet%40pacificcontours.com> >
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Sent: Thursday, April 18, 2013 10:55 AM
Subject: [Vantage] Epicor 9 Performance Issues

Recently our Epicor performance went from OK to Horrible.
We are currently on 9.05.606, Progress Database.

MRP used to take about 5 to 6 hours to run, now it takes 15 hours.
Releasing jobs used to take 1 second now takes a minute.
Same for POs.

We didn't add any BPMs or change any settings.

Has anyone experienced similar issues and resolved them some how?

I've heard in the past that if a data table on a progress database
reaches 2 million records that it slows down the database... can anyone
confirm this?
our change log table is 15 million records. TranGLC is 1.99 million
records and GLJrnlGLC is 1.76 million.

------------------------------------

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links

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

This e-mail and any attachments may contain proprietary and/or
confidential information. If you are not the intended recipient, please
notify the sender immediately by reply e-mail or at 410-472-2900 and
then delete the message without using, disseminating, or copying this
message or any portion thereof. With e-mail communications you are urged
to protect against viruses.

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

------------------------------------

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links

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





[Non-text portions of this message have been removed]
Good Day Ted:



We have found that re-booting weekly seems to prevent
various odd things. That has been true for all of the ERP systems we
have used.



I am reminded of the line in the movie "I, Robot" where the
Uber-Expert says something like "In the robots, there are always random
lines of code that seem to be created, and that they will someday
combine to become be the beginning of independent thought that will
overrule the "Three Laws Safe" paradigm".

In the real world, the world of ENTERPRISE ERP, they just
create potholes for the data packets.





Sun is on E9 Verion: 9.05.700C - SQL- Unidata - Enterprise-since
4/15/2012

Went live on 9.05.600B on 11/22/2010

Previously used M2K ( Manage 2000, ver 7.0 SP5) from 7/4/2001

Previously used INMASS ( 1998 )




Len







From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Ted Koch
Sent: Thursday, April 18, 2013 1:19 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Epicor 9 Performance Issues





Hi Len,

Epicor 9.05.701 Progress.

Currently the server has been up for 26 days. Is it a good idea to
restart the entire server weekly?

________________________________
From: Len Hartka <len.hartka@...
<mailto:len.hartka%40sunautomation.com> >
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Sent: Thursday, April 18, 2013 1:01 PM
Subject: RE: [Vantage] Epicor 9 Performance Issues


Good Day Ted:

Version and Progress?

Do you re-boot the servers once a week?

Temp files build up.



Len

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Ted Koch
Sent: Thursday, April 18, 2013 11:39 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: Re: [Vantage] Epicor 9 Performance Issues



We have recently started seeing sluggishness in Epicor the past couple
months as well. We did a dump and load and reindex but it still
sometimes takes 5-10 seconds if not longer to open a job in job entry or
to save records. Interested too what people are doing/have done to get
better performance. Is there a guide Epicor provides that would show how
to tweak the database or anything else to get better performance?

________________________________
From: supertico05 <mvissuet@...
<mailto:mvissuet%40pacificcontours.com>
<mailto:mvissuet%40pacificcontours.com> >
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Sent: Thursday, April 18, 2013 10:55 AM
Subject: [Vantage] Epicor 9 Performance Issues

Recently our Epicor performance went from OK to Horrible.
We are currently on 9.05.606, Progress Database.

MRP used to take about 5 to 6 hours to run, now it takes 15 hours.
Releasing jobs used to take 1 second now takes a minute.
Same for POs.

We didn't add any BPMs or change any settings.

Has anyone experienced similar issues and resolved them some how?

I've heard in the past that if a data table on a progress database
reaches 2 million records that it slows down the database... can anyone
confirm this?
our change log table is 15 million records. TranGLC is 1.99 million
records and GLJrnlGLC is 1.76 million.

------------------------------------

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links

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

This e-mail and any attachments may contain proprietary and/or
confidential information. If you are not the intended recipient, please
notify the sender immediately by reply e-mail or at 410-472-2900 and
then delete the message without using, disseminating, or copying this
message or any portion thereof. With e-mail communications you are urged
to protect against viruses.

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

------------------------------------

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links

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





This e-mail and any attachments may contain proprietary and/or confidential information. If you are not the intended recipient, please notify the sender immediately by reply e-mail or at 410-472-2900 and then delete the message without using, disseminating, or copying this message or any portion thereof. With e-mail communications you are urged to protect against viruses.


[Non-text portions of this message have been removed]
We too have automatic restarts of the app server every saturday night at 10pm. Does seem to keep things far more stable.



Joshua Giese

CTO

920.437.6400 Ext. 337

Site ID: 27450-E905700B2-SQL64

----- Original Message -----

From: "Len Hartka" <len.hartka@...>
To: vantage@yahoogroups.com
Sent: Thursday, April 18, 2013 12:30:16 PM
Subject: RE: [Vantage] Epicor 9 Performance Issues



Good Day Ted:

We have found that re-booting weekly seems to prevent
various odd things. That has been true for all of the ERP systems we
have used.

I am reminded of the line in the movie "I, Robot" where the
Uber-Expert says something like "In the robots, there are always random
lines of code that seem to be created, and that they will someday
combine to become be the beginning of independent thought that will
overrule the "Three Laws Safe" paradigm".

In the real world, the world of ENTERPRISE ERP, they just
create potholes for the data packets.

Sun is on E9 Verion: 9.05.700C - SQL- Unidata - Enterprise-since
4/15/2012

Went live on 9.05.600B on 11/22/2010

Previously used M2K ( Manage 2000, ver 7.0 SP5) from 7/4/2001

Previously used INMASS ( 1998 )

Len

From: vantage@yahoogroups.com [mailto: vantage@yahoogroups.com ] On Behalf
Of Ted Koch
Sent: Thursday, April 18, 2013 1:19 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Epicor 9 Performance Issues

Hi Len,

Epicor 9.05.701 Progress.

Currently the server has been up for 26 days. Is it a good idea to
restart the entire server weekly?

________________________________
From: Len Hartka < len.hartka@...
<mailto:len.hartka%40sunautomation.com> >
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Sent: Thursday, April 18, 2013 1:01 PM
Subject: RE: [Vantage] Epicor 9 Performance Issues

Good Day Ted:

Version and Progress?

Do you re-boot the servers once a week?

Temp files build up.

Len

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Ted Koch
Sent: Thursday, April 18, 2013 11:39 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: Re: [Vantage] Epicor 9 Performance Issues

We have recently started seeing sluggishness in Epicor the past couple
months as well. We did a dump and load and reindex but it still
sometimes takes 5-10 seconds if not longer to open a job in job entry or
to save records. Interested too what people are doing/have done to get
better performance. Is there a guide Epicor provides that would show how
to tweak the database or anything else to get better performance?

________________________________
From: supertico05 < mvissuet@...
<mailto:mvissuet%40pacificcontours.com>
<mailto:mvissuet%40pacificcontours.com> >
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Sent: Thursday, April 18, 2013 10:55 AM
Subject: [Vantage] Epicor 9 Performance Issues

Recently our Epicor performance went from OK to Horrible.
We are currently on 9.05.606, Progress Database.

MRP used to take about 5 to 6 hours to run, now it takes 15 hours.
Releasing jobs used to take 1 second now takes a minute.
Same for POs.

We didn't add any BPMs or change any settings.

Has anyone experienced similar issues and resolved them some how?

I've heard in the past that if a data table on a progress database
reaches 2 million records that it slows down the database... can anyone
confirm this?
our change log table is 15 million records. TranGLC is 1.99 million
records and GLJrnlGLC is 1.76 million.

------------------------------------

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
< http://groups.yahoo.com/group/vantage/files/ >
< http://groups.yahoo.com/group/vantage/files/ >
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/linksYahoo ! Groups Links

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

This e-mail and any attachments may contain proprietary and/or
confidential information. If you are not the intended recipient, please
notify the sender immediately by reply e-mail or at 410-472-2900 and
then delete the message without using, disseminating, or copying this
message or any portion thereof. With e-mail communications you are urged
to protect against viruses.

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

------------------------------------

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
< http://groups.yahoo.com/group/vantage/files/ >
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/linksYahoo ! Groups Links

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

This e-mail and any attachments may contain proprietary and/or confidential information. If you are not the intended recipient, please notify the sender immediately by reply e-mail or at 410-472-2900 and then delete the message without using, disseminating, or copying this message or any portion thereof. With e-mail communications you are urged to protect against viruses.

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





[Non-text portions of this message have been removed]
Ted:
Â
i would recomend you to look at the record scatter factor on the Database and perform the Dump & Load. This will for sure improve the performance on the database.
Â
We have done a dump and load and it has improved the performance.
Â
Thanks,
Doma Reddy.


________________________________
From: Len Hartka <len.hartka@...>
To: vantage@yahoogroups.com
Sent: Thursday, April 18, 2013 12:30 PM
Subject: RE: [Vantage] Epicor 9 Performance Issues



Â

Good Day Ted:

We have found that re-booting weekly seems to prevent
various odd things. That has been true for all of the ERP systems we
have used.

I am reminded of the line in the movie "I, Robot" where the
Uber-Expert says something like "In the robots, there are always random
lines of code that seem to be created, and that they will someday
combine to become be the beginning of independent thought that will
overrule the "Three Laws Safe" paradigm".

In the real world, the world of ENTERPRISE ERP, they just
create potholes for the data packets.

Sun is on E9 Verion: 9.05.700C - SQL- Unidata - Enterprise-since
4/15/2012

Went live on 9.05.600B on 11/22/2010

Previously used M2K ( Manage 2000, ver 7.0 SP5) from 7/4/2001

Previously used INMASS ( 1998 )

Len

From: mailto:vantage%40yahoogroups.com [mailto:mailto:vantage%40yahoogroups.com] On Behalf
Of Ted Koch
Sent: Thursday, April 18, 2013 1:19 PM
To: mailto:vantage%40yahoogroups.com
Subject: Re: [Vantage] Epicor 9 Performance Issues

Hi Len,

Epicor 9.05.701 Progress.

Currently the server has been up for 26 days. Is it a good idea to
restart the entire server weekly?

________________________________
From: Len Hartka <mailto:len.hartka%40sunautomation.com
<mailto:len.hartka%40sunautomation.com> >
To: mailto:vantage%40yahoogroups.com <mailto:vantage%40yahoogroups.com>
Sent: Thursday, April 18, 2013 1:01 PM
Subject: RE: [Vantage] Epicor 9 Performance Issues

Good Day Ted:

Version and Progress?

Do you re-boot the servers once a week?

Temp files build up.

Len

From: mailto:vantage%40yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:mailto:vantage%40yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Ted Koch
Sent: Thursday, April 18, 2013 11:39 AM
To: mailto:vantage%40yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: Re: [Vantage] Epicor 9 Performance Issues

We have recently started seeing sluggishness in Epicor the past couple
months as well. We did a dump and load and reindex but it still
sometimes takes 5-10 seconds if not longer to open a job in job entry or
to save records. Interested too what people are doing/have done to get
better performance. Is there a guide Epicor provides that would show how
to tweak the database or anything else to get better performance?

________________________________
From: supertico05 <mailto:mvissuet%40pacificcontours.com
<mailto:mvissuet%40pacificcontours.com>
<mailto:mvissuet%40pacificcontours.com> >
To: mailto:vantage%40yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Sent: Thursday, April 18, 2013 10:55 AM
Subject: [Vantage] Epicor 9 Performance Issues

Recently our Epicor performance went from OK to Horrible.
We are currently on 9.05.606, Progress Database.

MRP used to take about 5 to 6 hours to run, now it takes 15 hours.
Releasing jobs used to take 1 second now takes a minute.
Same for POs.

We didn't add any BPMs or change any settings.

Has anyone experienced similar issues and resolved them some how?

I've heard in the past that if a data table on a progress database
reaches 2 million records that it slows down the database... can anyone
confirm this?
our change log table is 15 million records. TranGLC is 1.99 million
records and GLJrnlGLC is 1.76 million.

------------------------------------

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links

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

This e-mail and any attachments may contain proprietary and/or
confidential information. If you are not the intended recipient, please
notify the sender immediately by reply e-mail or at 410-472-2900 and
then delete the message without using, disseminating, or copying this
message or any portion thereof. With e-mail communications you are urged
to protect against viruses.

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

------------------------------------

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/
<http://groups.yahoo.com/group/vantage/files/>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links

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

This e-mail and any attachments may contain proprietary and/or confidential information. If you are not the intended recipient, please notify the sender immediately by reply e-mail or at 410-472-2900 and then delete the message without using, disseminating, or copying this message or any portion thereof. With e-mail communications you are urged to protect against viruses.

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




[Non-text portions of this message have been removed]
Does anyone have an example of a batch file that would restart the appservers they could shared?

Thanks!




________________________________
From: Len Hartka <len.hartka@...>
To: vantage@yahoogroups.com
Sent: Thursday, April 18, 2013 1:30 PM
Subject: RE: [Vantage] Epicor 9 Performance Issues


Good Day Ted:



      We have found that re-booting weekly seems to prevent
various odd things. That has been true for all of the ERP systems we
have used.



      I am reminded of the line in the movie "I, Robot" where the
Uber-Expert says something like "In the robots, there are always random
lines of code that seem to be created, and that they will someday
combine to become be the beginning of independent thought that will
overrule the "Three Laws Safe" paradigm".

      In the real world, the world of ENTERPRISE ERP, they just
create potholes for the data packets.





Sun is on E9 Verion:Â 9.05.700C - SQL- Unidata - Enterprise-since
4/15/2012

 Went live on 9.05.600B on 11/22/2010

Previously used M2K ( Manage 2000, ver 7.0 SP5) from 7/4/2001

Previously used INMASS ( 1998 )




Len







From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Ted Koch
Sent: Thursday, April 18, 2013 1:19 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Epicor 9 Performance Issues



Â

Hi Len,

Epicor 9.05.701 Progress.

Currently the server has been up for 26 days. Is it a good idea to
restart the entire server weekly?

________________________________
From: Len Hartka <len.hartka@...
<mailto:len.hartka%40sunautomation.com> >
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>Â
Sent: Thursday, April 18, 2013 1:01 PM
Subject: RE: [Vantage] Epicor 9 Performance Issues


Good Day Ted:

      Version and Progress?

      Do you re-boot the servers once a week?Â

      Temp files build up.

     Â

Len

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Ted Koch
Sent: Thursday, April 18, 2013 11:39 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: Re: [Vantage] Epicor 9 Performance Issues

Â

We have recently started seeing sluggishness in Epicor the past couple
months as well. We did a dump and load and reindex but it still
sometimes takes 5-10 seconds if not longer to open a job in job entry or
to save records. Interested too what people are doing/have done to get
better performance. Is there a guide Epicor provides that would show how
to tweak the database or anything else to get better performance?

________________________________
From: supertico05 <mvissuet@...
<mailto:mvissuet%40pacificcontours.com>
<mailto:mvissuet%40pacificcontours.com> >
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>Â
Sent: Thursday, April 18, 2013 10:55 AM
Subject: [Vantage] Epicor 9 Performance Issues

Recently our Epicor performance went from OK to Horrible.Â
We are currently on 9.05.606, Progress Database.

MRP used to take about 5 to 6 hours to run, now it takes 15 hours.
Releasing jobs used to take 1 second now takes a minute.
Same for POs.

We didn't add any BPMs or change any settings.

Has anyone experienced similar issues and resolved them some how?

I've heard in the past that if a data table on a progress database
reaches 2 million records that it slows down the database... can anyone
confirm this?
our change log table is 15 million records. TranGLC is 1.99 million
records and GLJrnlGLC is 1.76 million.

------------------------------------

Useful links for the Yahoo!Groups Vantage Board are: ( Note:Â You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links

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

This e-mail and any attachments may contain proprietary and/or
confidential information. If you are not the intended recipient, please
notify the sender immediately by reply e-mail or at 410-472-2900 and
then delete the message without using, disseminating, or copying this
message or any portion thereof. With e-mail communications you are urged
to protect against viruses.

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

------------------------------------

Useful links for the Yahoo!Groups Vantage Board are: ( Note:Â You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links

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





This e-mail and any attachments may contain proprietary and/or confidential information. If you are not the intended recipient, please notify the sender immediately by reply e-mail or at 410-472-2900 and then delete the message without using, disseminating, or copying this message or any portion thereof. With e-mail communications you are urged to protect against viruses.


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



------------------------------------

Useful links for the Yahoo!Groups Vantage Board are: ( Note:Â You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links



[Non-text portions of this message have been removed]
Do you have a copy of the instructions on how to perform a dump and load?


Marco Vissuet
Systems Engineer
Pacific Contours Corporation
Cell (619)507-2311
Anaheim Office (714) 693-1260
San Diego Office (619)670-3900
Fax (714) 693-1252
mvissuet@...<mailto:marcov@...>
http://www.pacificcontours.com/

"The information contained herein may be subject to the International Traffic in Arms Regulations (ITAR) Warning: - This document contains data whose export is restricted by the Arms Export Control Act (Title 22, U.S.C., Sec 2751, et seq.) as amended, or the Export Administration Act (Title 50, U.S.C., App 2401 et seq.) as amended. Violations of these export laws are subject to severe criminal and civil penalties. Disseminate in accordance with provisions of DoD Directive 5230.25.

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Doma Reddy
Sent: Thursday, April 18, 2013 10:35 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Epicor 9 Performance Issues



Ted:

i would recomend you to look at the record scatter factor on the Database and perform the Dump & Load. This will for sure improve the performance on the database.

We have done a dump and load and it has improved the performance.

Thanks,
Doma Reddy.


________________________________
From: Len Hartka <len.hartka@...<mailto:len.hartka%40sunautomation.com>>
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
Sent: Thursday, April 18, 2013 12:30 PM
Subject: RE: [Vantage] Epicor 9 Performance Issues





Good Day Ted:

We have found that re-booting weekly seems to prevent
various odd things. That has been true for all of the ERP systems we
have used.

I am reminded of the line in the movie "I, Robot" where the
Uber-Expert says something like "In the robots, there are always random
lines of code that seem to be created, and that they will someday
combine to become be the beginning of independent thought that will
overrule the "Three Laws Safe" paradigm".

In the real world, the world of ENTERPRISE ERP, they just
create potholes for the data packets.

Sun is on E9 Verion: 9.05.700C - SQL- Unidata - Enterprise-since
4/15/2012

Went live on 9.05.600B on 11/22/2010

Previously used M2K ( Manage 2000, ver 7.0 SP5) from 7/4/2001

Previously used INMASS ( 1998 )

Len

From: mailto:vantage%40yahoogroups.com [mailto:mailto:vantage%40yahoogroups.com] On Behalf
Of Ted Koch
Sent: Thursday, April 18, 2013 1:19 PM
To: mailto:vantage%40yahoogroups.com
Subject: Re: [Vantage] Epicor 9 Performance Issues

Hi Len,

Epicor 9.05.701 Progress.

Currently the server has been up for 26 days. Is it a good idea to
restart the entire server weekly?

________________________________
From: Len Hartka <mailto:len.hartka%40sunautomation.com
<mailto:len.hartka%40sunautomation.com<mailto:len.hartka%40sunautomation.com%0b%3cmailto:len.hartka%40sunautomation.com>> >
To: mailto:vantage%40yahoogroups.com <mailto:vantage%40yahoogroups.com>
Sent: Thursday, April 18, 2013 1:01 PM
Subject: RE: [Vantage] Epicor 9 Performance Issues

Good Day Ted:

Version and Progress?

Do you re-boot the servers once a week?

Temp files build up.

Len

From: mailto:vantage%40yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:mailto:vantage%40yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Ted Koch
Sent: Thursday, April 18, 2013 11:39 AM
To: mailto:vantage%40yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: Re: [Vantage] Epicor 9 Performance Issues

We have recently started seeing sluggishness in Epicor the past couple
months as well. We did a dump and load and reindex but it still
sometimes takes 5-10 seconds if not longer to open a job in job entry or
to save records. Interested too what people are doing/have done to get
better performance. Is there a guide Epicor provides that would show how
to tweak the database or anything else to get better performance?

________________________________
From: supertico05 <mailto:mvissuet%40pacificcontours.com
<mailto:mvissuet%40pacificcontours.com<mailto:mvissuet%40pacificcontours.com%0b%3cmailto:mvissuet%40pacificcontours.com>>
<mailto:mvissuet%40pacificcontours.com> >
To: mailto:vantage%40yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Sent: Thursday, April 18, 2013 10:55 AM
Subject: [Vantage] Epicor 9 Performance Issues

Recently our Epicor performance went from OK to Horrible.
We are currently on 9.05.606, Progress Database.

MRP used to take about 5 to 6 hours to run, now it takes 15 hours.
Releasing jobs used to take 1 second now takes a minute.
Same for POs.

We didn't add any BPMs or change any settings.

Has anyone experienced similar issues and resolved them some how?

I've heard in the past that if a data table on a progress database
reaches 2 million records that it slows down the database... can anyone
confirm this?
our change log table is 15 million records. TranGLC is 1.99 million
records and GLJrnlGLC is 1.76 million.




Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links

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

This e-mail and any attachments may contain proprietary and/or
confidential information. If you are not the intended recipient, please
notify the sender immediately by reply e-mail or at 410-472-2900 and
then delete the message without using, disseminating, or copying this
message or any portion thereof. With e-mail communications you are urged
to protect against viruses.

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




Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/
<http://groups.yahoo.com/group/vantage/files/>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links

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

This e-mail and any attachments may contain proprietary and/or confidential information. If you are not the intended recipient, please notify the sender immediately by reply e-mail or at 410-472-2900 and then delete the message without using, disseminating, or copying this message or any portion thereof. With e-mail communications you are urged to protect against viruses.

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

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



__________ Information from ESET NOD32 Antivirus, version of virus signature database 8242 (20130418) __________


The message was checked by ESET NOD32 Antivirus.


http://www.eset.com


[Non-text portions of this message have been removed]
We performed a dump and load 2 months or less ago. I shouldn't have to be doing that monthly I'm pretty sure.




________________________________
From: Doma Reddy <domareddy@...>
To: "vantage@yahoogroups.com" <vantage@yahoogroups.com>
Sent: Thursday, April 18, 2013 1:34 PM
Subject: Re: [Vantage] Epicor 9 Performance Issues


Ted:
Â
i would recomend you to look at the record scatter factor on the Database and perform the Dump & Load. This will for sure improve the performance on the database.
Â
We have done a dump and load and it has improved the performance.
Â
Thanks,
Doma Reddy.


________________________________
From: Len Hartka <len.hartka@...>
To: vantage@yahoogroups.com
Sent: Thursday, April 18, 2013 12:30 PM
Subject: RE: [Vantage] Epicor 9 Performance Issues
Â


 Â

Good Day Ted:

We have found that re-booting weekly seems to prevent
various odd things. That has been true for all of the ERP systems we
have used.

I am reminded of the line in the movie "I, Robot" where the
Uber-Expert says something like "In the robots, there are always random
lines of code that seem to be created, and that they will someday
combine to become be the beginning of independent thought that will
overrule the "Three Laws Safe" paradigm".

In the real world, the world of ENTERPRISE ERP, they just
create potholes for the data packets.

Sun is on E9 Verion:Â 9.05.700C - SQL- Unidata - Enterprise-since
4/15/2012

Went live on 9.05.600B on 11/22/2010

Previously used M2K ( Manage 2000, ver 7.0 SP5) from 7/4/2001

Previously used INMASS ( 1998 )

Len

From: mailto:vantage%40yahoogroups.com [mailto:mailto:vantage%40yahoogroups.com] On Behalf
Of Ted Koch
Sent: Thursday, April 18, 2013 1:19 PM
To: mailto:vantage%40yahoogroups.com
Subject: Re: [Vantage] Epicor 9 Performance Issues

Hi Len,

Epicor 9.05.701 Progress.

Currently the server has been up for 26 days. Is it a good idea to
restart the entire server weekly?

________________________________
From: Len Hartka <mailto:len.hartka%40sunautomation.com
<mailto:len.hartka%40sunautomation.com> >
To: mailto:vantage%40yahoogroups.com <mailto:vantage%40yahoogroups.com>
Sent: Thursday, April 18, 2013 1:01 PM
Subject: RE: [Vantage] Epicor 9 Performance Issues

Good Day Ted:

Version and Progress?

Do you re-boot the servers once a week?

Temp files build up.

Len

From: mailto:vantage%40yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:mailto:vantage%40yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Ted Koch
Sent: Thursday, April 18, 2013 11:39 AM
To: mailto:vantage%40yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: Re: [Vantage] Epicor 9 Performance Issues

We have recently started seeing sluggishness in Epicor the past couple
months as well. We did a dump and load and reindex but it still
sometimes takes 5-10 seconds if not longer to open a job in job entry or
to save records. Interested too what people are doing/have done to get
better performance. Is there a guide Epicor provides that would show how
to tweak the database or anything else to get better performance?

________________________________
From: supertico05 <mailto:mvissuet%40pacificcontours.com
<mailto:mvissuet%40pacificcontours.com>
<mailto:mvissuet%40pacificcontours.com> >
To: mailto:vantage%40yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Sent: Thursday, April 18, 2013 10:55 AM
Subject: [Vantage] Epicor 9 Performance Issues

Recently our Epicor performance went from OK to Horrible.
We are currently on 9.05.606, Progress Database.

MRP used to take about 5 to 6 hours to run, now it takes 15 hours.
Releasing jobs used to take 1 second now takes a minute.
Same for POs.

We didn't add any BPMs or change any settings.

Has anyone experienced similar issues and resolved them some how?

I've heard in the past that if a data table on a progress database
reaches 2 million records that it slows down the database... can anyone
confirm this?
our change log table is 15 million records. TranGLC is 1.99 million
records and GLJrnlGLC is 1.76 million.

------------------------------------

Useful links for the Yahoo!Groups Vantage Board are: ( Note:Â You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links

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

This e-mail and any attachments may contain proprietary and/or
confidential information. If you are not the intended recipient, please
notify the sender immediately by reply e-mail or at 410-472-2900 and
then delete the message without using, disseminating, or copying this
message or any portion thereof. With e-mail communications you are urged
to protect against viruses.

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

------------------------------------

Useful links for the Yahoo!Groups Vantage Board are: ( Note:Â You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/
<http://groups.yahoo.com/group/vantage/files/>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links

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

This e-mail and any attachments may contain proprietary and/or confidential information. If you are not the intended recipient, please notify the sender immediately by reply e-mail or at 410-472-2900 and then delete the message without using, disseminating, or copying this message or any portion thereof. With e-mail communications you are urged to protect against viruses.

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

Â
   Â

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



------------------------------------

Useful links for the Yahoo!Groups Vantage Board are: ( Note:Â You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links



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



Here is an example of starting the app servers.



Regards,

Sigfredo.



set DLC=d:\Epicor\OE102a

set PATH=%DLC%\BIN;%PATH%

set LIB=%DLC%\LIB;%LIB%



echo .

echo .

echo STARTING LOCAL APPSERVERS



call asbman -name Epicor905 -start

call asbman -name Epicor905TaskAgent -start

call asbman -name Epicor905ProcessServer -start





call asbman -name EpicorTest905 -start

call asbman -name EpicorTest905TaskAgent -start

call asbman -name EpicorTest905ProcessServer -start





From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Ted Koch
Sent: Thursday, April 18, 2013 1:40 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Epicor 9 Performance Issues





Does anyone have an example of a batch file that would restart the
appservers they could shared?

Thanks!

________________________________
From: Len Hartka <len.hartka@...
<mailto:len.hartka%40sunautomation.com> >
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Sent: Thursday, April 18, 2013 1:30 PM
Subject: RE: [Vantage] Epicor 9 Performance Issues


Good Day Ted:

We have found that re-booting weekly seems to prevent
various odd things. That has been true for all of the ERP systems we
have used.

I am reminded of the line in the movie "I, Robot" where the
Uber-Expert says something like "In the robots, there are always random
lines of code that seem to be created, and that they will someday
combine to become be the beginning of independent thought that will
overrule the "Three Laws Safe" paradigm".

In the real world, the world of ENTERPRISE ERP, they just
create potholes for the data packets.

Sun is on E9 Verion: 9.05.700C - SQL- Unidata - Enterprise-since
4/15/2012

Went live on 9.05.600B on 11/22/2010

Previously used M2K ( Manage 2000, ver 7.0 SP5) from 7/4/2001

Previously used INMASS ( 1998 )

Len

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Ted Koch
Sent: Thursday, April 18, 2013 1:19 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: Re: [Vantage] Epicor 9 Performance Issues



Hi Len,

Epicor 9.05.701 Progress.

Currently the server has been up for 26 days. Is it a good idea to
restart the entire server weekly?

________________________________
From: Len Hartka <len.hartka@...
<mailto:len.hartka%40sunautomation.com>
<mailto:len.hartka%40sunautomation.com> >
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Sent: Thursday, April 18, 2013 1:01 PM
Subject: RE: [Vantage] Epicor 9 Performance Issues

Good Day Ted:

Version and Progress?

Do you re-boot the servers once a week?

Temp files build up.



Len

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 Ted Koch
Sent: Thursday, April 18, 2013 11:39 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: Re: [Vantage] Epicor 9 Performance Issues



We have recently started seeing sluggishness in Epicor the past couple
months as well. We did a dump and load and reindex but it still
sometimes takes 5-10 seconds if not longer to open a job in job entry or
to save records. Interested too what people are doing/have done to get
better performance. Is there a guide Epicor provides that would show how
to tweak the database or anything else to get better performance?

________________________________
From: supertico05 <mvissuet@...
<mailto:mvissuet%40pacificcontours.com>
<mailto:mvissuet%40pacificcontours.com>
<mailto:mvissuet%40pacificcontours.com> >
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Sent: Thursday, April 18, 2013 10:55 AM
Subject: [Vantage] Epicor 9 Performance Issues

Recently our Epicor performance went from OK to Horrible.
We are currently on 9.05.606, Progress Database.

MRP used to take about 5 to 6 hours to run, now it takes 15 hours.
Releasing jobs used to take 1 second now takes a minute.
Same for POs.

We didn't add any BPMs or change any settings.

Has anyone experienced similar issues and resolved them some how?

I've heard in the past that if a data table on a progress database
reaches 2 million records that it slows down the database... can anyone
confirm this?
our change log table is 15 million records. TranGLC is 1.99 million
records and GLJrnlGLC is 1.76 million.

------------------------------------

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links

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

This e-mail and any attachments may contain proprietary and/or
confidential information. If you are not the intended recipient, please
notify the sender immediately by reply e-mail or at 410-472-2900 and
then delete the message without using, disseminating, or copying this
message or any portion thereof. With e-mail communications you are urged
to protect against viruses.

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

------------------------------------

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links

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

This e-mail and any attachments may contain proprietary and/or
confidential information. If you are not the intended recipient, please
notify the sender immediately by reply e-mail or at 410-472-2900 and
then delete the message without using, disseminating, or copying this
message or any portion thereof. With e-mail communications you are urged
to protect against viruses.

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

------------------------------------

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links

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





[Non-text portions of this message have been removed]
Hi Marco,
Â
I do not have the latest document, you should be able to get one from the support. There are 2 dump & Load procedures i.e. ASCII D&L, Binary D&L make sure you ask support which one do they refer to your DB. I have done the ASCII D&L in the past.
Â
Thanks,
Doma Reddy.

 Â

________________________________
From: Marco Vissuet <mvissuet@...>
To: "vantage@yahoogroups.com" <vantage@yahoogroups.com>
Sent: Thursday, April 18, 2013 12:46 PM
Subject: RE: [Vantage] Epicor 9 Performance Issues


Â

Do you have a copy of the instructions on how to perform a dump and load?


Marco Vissuet
Systems Engineer
Pacific Contours Corporation
Cell (619)507-2311
Anaheim Office (714) 693-1260
San Diego Office (619)670-3900
Fax (714) 693-1252
mailto:mvissuet%40pacificcontours.com<mailto:mailto:marcov%40pacificcontours.com>
http://www.pacificcontours.com/

"The information contained herein may be subject to the International Traffic in Arms Regulations (ITAR) Warning: - This document contains data whose export is restricted by the Arms Export Control Act (Title 22, U.S.C., Sec 2751, et seq.) as amended, or the Export Administration Act (Title 50, U.S.C., App 2401 et seq.) as amended. Violations of these export laws are subject to severe criminal and civil penalties. Disseminate in accordance with provisions of DoD Directive 5230.25.

From: mailto:vantage%40yahoogroups.com [mailto:mailto:vantage%40yahoogroups.com] On Behalf Of Doma Reddy
Sent: Thursday, April 18, 2013 10:35 AM
To: mailto:vantage%40yahoogroups.com
Subject: Re: [Vantage] Epicor 9 Performance Issues



Ted:

i would recomend you to look at the record scatter factor on the Database and perform the Dump & Load. This will for sure improve the performance on the database.

We have done a dump and load and it has improved the performance.

Thanks,
Doma Reddy.


________________________________
From: Len Hartka <mailto:len.hartka%40sunautomation.com<mailto:len.hartka%40sunautomation.com>>
To: mailto:vantage%40yahoogroups.com<mailto:vantage%40yahoogroups.com>
Sent: Thursday, April 18, 2013 12:30 PM
Subject: RE: [Vantage] Epicor 9 Performance Issues





Good Day Ted:

We have found that re-booting weekly seems to prevent
various odd things. That has been true for all of the ERP systems we
have used.

I am reminded of the line in the movie "I, Robot" where the
Uber-Expert says something like "In the robots, there are always random
lines of code that seem to be created, and that they will someday
combine to become be the beginning of independent thought that will
overrule the "Three Laws Safe" paradigm".

In the real world, the world of ENTERPRISE ERP, they just
create potholes for the data packets.

Sun is on E9 Verion: 9.05.700C - SQL- Unidata - Enterprise-since
4/15/2012

Went live on 9.05.600B on 11/22/2010

Previously used M2K ( Manage 2000, ver 7.0 SP5) from 7/4/2001

Previously used INMASS ( 1998 )

Len

From: mailto:vantage%40yahoogroups.com [mailto:mailto:vantage%40yahoogroups.com] On Behalf
Of Ted Koch
Sent: Thursday, April 18, 2013 1:19 PM
To: mailto:vantage%40yahoogroups.com
Subject: Re: [Vantage] Epicor 9 Performance Issues

Hi Len,

Epicor 9.05.701 Progress.

Currently the server has been up for 26 days. Is it a good idea to
restart the entire server weekly?

________________________________
From: Len Hartka <mailto:len.hartka%40sunautomation.com
<mailto:len.hartka%40sunautomation.com<mailto:len.hartka%40sunautomation.com%0b%3cmailto:len.hartka%40sunautomation.com>> >
To: mailto:vantage%40yahoogroups.com <mailto:vantage%40yahoogroups.com>
Sent: Thursday, April 18, 2013 1:01 PM
Subject: RE: [Vantage] Epicor 9 Performance Issues

Good Day Ted:

Version and Progress?

Do you re-boot the servers once a week?

Temp files build up.

Len

From: mailto:vantage%40yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:mailto:vantage%40yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Ted Koch
Sent: Thursday, April 18, 2013 11:39 AM
To: mailto:vantage%40yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: Re: [Vantage] Epicor 9 Performance Issues

We have recently started seeing sluggishness in Epicor the past couple
months as well. We did a dump and load and reindex but it still
sometimes takes 5-10 seconds if not longer to open a job in job entry or
to save records. Interested too what people are doing/have done to get
better performance. Is there a guide Epicor provides that would show how
to tweak the database or anything else to get better performance?

________________________________
From: supertico05 <mailto:mvissuet%40pacificcontours.com
<mailto:mvissuet%40pacificcontours.com<mailto:mvissuet%40pacificcontours.com%0b%3cmailto:mvissuet%40pacificcontours.com>>
<mailto:mvissuet%40pacificcontours.com> >
To: mailto:vantage%40yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Sent: Thursday, April 18, 2013 10:55 AM
Subject: [Vantage] Epicor 9 Performance Issues

Recently our Epicor performance went from OK to Horrible.
We are currently on 9.05.606, Progress Database.

MRP used to take about 5 to 6 hours to run, now it takes 15 hours.
Releasing jobs used to take 1 second now takes a minute.
Same for POs.

We didn't add any BPMs or change any settings.

Has anyone experienced similar issues and resolved them some how?

I've heard in the past that if a data table on a progress database
reaches 2 million records that it slows down the database... can anyone
confirm this?
our change log table is 15 million records. TranGLC is 1.99 million
records and GLJrnlGLC is 1.76 million.

------------------------------------

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links

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

This e-mail and any attachments may contain proprietary and/or
confidential information. If you are not the intended recipient, please
notify the sender immediately by reply e-mail or at 410-472-2900 and
then delete the message without using, disseminating, or copying this
message or any portion thereof. With e-mail communications you are urged
to protect against viruses.

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

------------------------------------

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/
<http://groups.yahoo.com/group/vantage/files/>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links

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

This e-mail and any attachments may contain proprietary and/or confidential information. If you are not the intended recipient, please notify the sender immediately by reply e-mail or at 410-472-2900 and then delete the message without using, disseminating, or copying this message or any portion thereof. With e-mail communications you are urged to protect against viruses.

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

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



__________ Information from ESET NOD32 Antivirus, version of virus signature database 8242 (20130418) __________


The message was checked by ESET NOD32 Antivirus.


http://www.eset.com/

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




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