Epicor 9 Performance Issues

system · April 19, 2013, 5:26pm

Create a file.

LiveRestart.bat

COPY AND PASTE
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

@echo off
echo Restarting Appservers
set DLC=D:\Epicor\OE102A
set PATH=%DLC%\BIN;%PATH%
set LIB=%DLC%\LIB;%LIB%

echo .
echo .

echo STOPPING LOCAL APPSERVERS AND DATABASE
call asbman -host localhost -name Epicor905ProcessServer -stop -port 20931
call asbman -host localhost -name Epicor905TaskAgent -stop -port 20931
call asbman -host localhost -name Epicor905PrintServer -stop -port 20931
call asbman -host localhost -name Epicor905 -stop -port 20931
REM call dbman -host localhost -database Epicor905 -stop -port 20931

ping 127.0.0.1 -n 30 -w 1000 > nul
echo .
echo .

echo STARTING LOCAL APPSERVERS AND DATABASE
REM call dbman -host localhost -database Epicor905 -start -port 20931
call asbman -host localhost -name Epicor905 -start -port 20931
call asbman -host localhost -name Epicor905PrintServer -start -port 20931
call asbman -host localhost -name Epicor905TaskAgent -start -port 20931
call asbman -host localhost -name Epicor905ProcessServer -start -port 20931

On your windows Task Scheduler run the bat file.

I have it restart every Saturday as well.

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Ted Koch
Sent: Thursday, April 18, 2013 10:40 AM
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]

system · May 10, 2013, 10:35pm

Hi Ted - did you find a solution? We're seeing the same issue lately.

Mike

--- In vantage@yahoogroups.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
> 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]
>

system · May 11, 2013, 1:02pm

There is no table size limit in Progress that creates a performance constraint. What will create a performance constraint is if the DB grows sufficiently that most of it can no longer be cached into memory and you have to rely on the I/O subsystem for primary read/write. There are, of course, solutions to this issue. You can upgrade to 64 bit to take advantage of the increased memory capacity. Also, you can create a multiple fixed extent DB and place each extent on a separate I/O channel as well as moving the B1 and A1 to separate disk subsystems.

Michael

Michael Barry
Aspacia Systems Inc
866.566.9600
312.803.0730 fax
http://www.aspacia.com/

On May 10, 2013, at 7:35 PM, mbarryjr1 <mikebarry@...> wrote:

> Hi Ted - did you find a solution? We're seeing the same issue lately.
>
> Mike
>
> --- In vantage@yahoogroups.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
> > 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]
> >
>
>

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

system · May 13, 2013, 3:17am

Do you regularly restart your apps and db?

________________________________
From: mbarryjr1 <mikebarry@...>
To: vantage@yahoogroups.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, 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
> 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]
>

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

system · May 13, 2013, 8:48am

Ted,

We had issues with our restart script hanging on the TaskAgent or the Print app servers. I think we have a working solution now, it is similar to what others have posted except it tries to kill the TaskAgent and the Print app servers simultaneously. This has better results for us.

REM --------------------------------------------
REM Re-start prod task/print/process app servers
REM --------------------------------------------

@echo off

set DLC=E:\Epicor\OE102A
set PATH=%DLC%\BIN;%PATH%
set LIB=%DLC%\LIB;%LIB%

echo Re-Stopping 9.05 Process, Task, Print app brokers
echo STOPPING LOCAL DB/APPSERVER...

call asbman -name Epicor905ProcessServer -stop
START cmd /c call asbman -name Epicor905TaskAgent -stop
call asbman -name Epicor905Print -stop

echo STARTING LOCAL DB/APPSERVER...

call asbman -name Epicor905Print -start
call asbman -name Epicor905TaskAgent -start
call asbman -name Epicor905ProcessServer -start

--- In vantage@yahoogroups.com, Ted Koch <tkoch77@...> wrote:
>
> Does anyone have an example of a batch file that would restart the appservers they could shared?
>
> Thanks!
>
>

system · May 13, 2013, 9:08am

This is the batch file I ended up creating. I have it scheduled to run every Saturday night, works fine. Also, there is a parameter in the MfgSys.pf file -Bt. I changed the -Bt value from its default of 4096 to the maximum value 50,000. This appears to have helped with performance substantially according to users. I also made some other changes that are referenced in the Epicor Performance Tuning Guide, the settings you can use all depend on your hardware.

set DLC=F:\epicor\oe102a
F:
cd \epicor\oe102a\bin

call asbman -name Epicor905ProcessServer -stop
call asbman -name Epicor905TaskAgent -stop
call asbman -name Epicor905 -stop
REM call dbman -database Epicor905 -stop

ping 127.0.0.1 -n 30 -w 1000 > nul

REM call dbman -database Epicor905 -start
call asbman -name Epicor905 -start
call asbman -name Epicor905TaskAgent -start
call asbman -name Epicor905ProcessServer -start

________________________________
From: adamnoffie <ygroups.adamleer@...>
To: vantage@yahoogroups.com
Sent: Monday, May 13, 2013 8:48 AM
Subject: [Vantage] Re: Epicor 9 Performance Issues

Ted,

We had issues with our restart script hanging on the TaskAgent or the Print app servers.Â I think we have a working solution now, it is similar to what others have posted except it tries to kill the TaskAgent and the Print app servers simultaneously.Â This has better results for us.

REM --------------------------------------------
REM Re-start prod task/print/process app servers
REM --------------------------------------------

@echo off

set DLC=E:\Epicor\OE102A
set PATH=%DLC%\BIN;%PATH%
set LIB=%DLC%\LIB;%LIB%

echo Re-Stopping 9.05 Process, Task, Print app brokers
echo STOPPING LOCAL DB/APPSERVER...

call asbman -name Epicor905ProcessServer -stop
START cmd /c call asbman -name Epicor905TaskAgent -stop
call asbman -name Epicor905Print -stop

echo STARTING LOCAL DB/APPSERVER...

call asbman -name Epicor905Print -start
call asbman -name Epicor905TaskAgent -start
call asbman -name Epicor905ProcessServer -start

--- In vantage@yahoogroups.com, Ted Koch <tkoch77@...> wrote:
>
> Does anyone have an example of a batch file that would restart the appservers they could shared?
>
> Thanks!
>
>

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

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]

system · May 13, 2013, 9:35am

Ours is massive long winded but it sends an email every step of the way so we know if/where it's failing. It also sends us an sms at the end.

@echo off

set DLC=E:\epicor904\oe101c
set PATH=%DLC%\BIN;%PATH%
set LIB=%DLC%\LIB;%LIB%

@echo off & setlocal
:: set the temp file location
set tempmail=%temp%\tempmail.%random%.txt
:: echo the basic headers to the temp file
echo To: "Backup Users" ^<backup.users@...^> > %tempmail%
echo From: "Epicor Daily Maintenance" ^<no-reply@...^> >> %tempmail%
echo Subject: Epicor Daily Maintenance: The 'stop_all_apps_dbs_and_service' script has started >> %tempmail%
:: echo the blank line that separates the header from the body text
echo.>>%tempmail%
:: echo the body text to the temp file
echo [DIAGNOSTIC MODE] The 'stop_all_apps_dbs_and_service' script has started successfully.>> %tempmail%
:: move the temp file to the mail pickup directory
:: adjust this location for your system
move %tempmail% C:\Inetpub\mailroot\Pickup
set tempmail=
endlocal

echo .
echo .
echo LIVE - STOPPING LOCAL APPSERVERS...

call asbman -name Epicor904ProcessServer -stop -port 20940

@echo off & setlocal
:: set the temp file location
set tempmail=%temp%\tempmail.%random%.txt
:: echo the basic headers to the temp file
echo To: "Backup Users" ^<backup.users@...^> > %tempmail%
echo From: "Epicor Daily Maintenance" ^<no-reply@...^> >> %tempmail%
echo Subject: Epicor Live ProcessServer has stopped >> %tempmail%
:: echo the blank line that separates the header from the body text
echo.>>%tempmail%
:: echo the body text to the temp file
echo [DIAGNOSTIC MODE] The Epicor Live ProcessServer has stopped successfully.>> %tempmail%
:: move the temp file to the mail pickup directory
:: adjust this location for your system
move %tempmail% C:\Inetpub\mailroot\Pickup
set tempmail=
endlocal

call asbman -name Epicor904TaskAgent -stop -port 20940

@echo off & setlocal
:: set the temp file location
set tempmail=%temp%\tempmail.%random%.txt
:: echo the basic headers to the temp file
echo To: "Backup Users" ^<backup.users@...^> > %tempmail%
echo From: "Epicor Daily Maintenance" ^<no-reply@...^> >> %tempmail%
echo Subject: Epicor Live TaskAgent has stopped >> %tempmail%
:: echo the blank line that separates the header from the body text
echo.>>%tempmail%
:: echo the body text to the temp file
echo [DIAGNOSTIC MODE] The Epicor Live TaskAgent has stopped successfully.>> %tempmail%
:: move the temp file to the mail pickup directory
:: adjust this location for your system
move %tempmail% C:\Inetpub\mailroot\Pickup
set tempmail=
endlocal

call asbman -name Epicor904PrintQueue -stop -port 20940

@echo off & setlocal
:: set the temp file location
set tempmail=%temp%\tempmail.%random%.txt
:: echo the basic headers to the temp file
echo To: "Backup Users" ^<backup.users@...^> > %tempmail%
echo From: "Epicor Daily Maintenance" ^<no-reply@...^> >> %tempmail%
echo Subject: Epicor Live PrintQueue has stopped >> %tempmail%
:: echo the blank line that separates the header from the body text
echo.>>%tempmail%
:: echo the body text to the temp file
echo [DIAGNOSTIC MODE] The Epicor Live PrintQueue has stopped successfully.>> %tempmail%
:: move the temp file to the mail pickup directory
:: adjust this location for your system
move %tempmail% C:\Inetpub\mailroot\Pickup
set tempmail=
endlocal

call asbman -name Epicor904 -stop -port 20940

@echo off & setlocal
:: set the temp file location
set tempmail=%temp%\tempmail.%random%.txt
:: echo the basic headers to the temp file
echo To: "Backup Users" ^<backup.users@...^> > %tempmail%
echo From: "Epicor Daily Maintenance" ^<no-reply@...^> >> %tempmail%
echo Subject: Epicor904 Live Appserver has stopped >> %tempmail%
:: echo the blank line that separates the header from the body text
echo.>>%tempmail%
:: echo the body text to the temp file
echo [DIAGNOSTIC MODE] The Epicor904 Live Appserver has stopped successfully.>> %tempmail%
:: move the temp file to the mail pickup directory
:: adjust this location for your system
move %tempmail% C:\Inetpub\mailroot\Pickup
set tempmail=
endlocal

echo .
echo LIVE - STOPPING LOCAL DATABASE...

call dbman -host localhost -database Epicor904 -stop -port 20940

@echo off & setlocal
:: set the temp file location
set tempmail=%temp%\tempmail.%random%.txt
:: echo the basic headers to the temp file
echo To: "Backup Users" ^<backup.users@...^> > %tempmail%
echo From: "Epicor Daily Maintenance" ^<no-reply@...^> >> %tempmail%
echo Subject: Epicor Live Database has stopped >> %tempmail%
:: echo the blank line that separates the header from the body text
echo.>>%tempmail%
:: echo the body text to the temp file
echo [DIAGNOSTIC MODE] The Epicor Live Database has stopped successfully.>> %tempmail%
:: move the temp file to the mail pickup directory
:: adjust this location for your system
move %tempmail% C:\Inetpub\mailroot\Pickup
set tempmail=
endlocal

Â
:TestStopLive
ECHO Testing Lock File
IF EXIST E:\epicor904\db\mfgsys.lk GOTO TestStopLive

@echo off & setlocal
:: set the temp file location
set tempmail=%temp%\tempmail.%random%.txt
:: echo the basic headers to the temp file
echo To: "Backup Users" ^<backup.users@...^> > %tempmail%
echo From: "Epicor Daily Maintenance" ^<no-reply@...^> >> %tempmail%
echo Subject: Epicor Live Database and Appservers >> %tempmail%
:: echo the blank line that separates the header from the body text
echo.>>%tempmail%
:: echo the body text to the temp file
echo [DIAGNOSTIC MODE] The Epicor Live Database and Appservers have all stopped successfully. Moving to Pilot.>> %tempmail%
:: move the temp file to the mail pickup directory
:: adjust this location for your system
move %tempmail% C:\Inetpub\mailroot\Pickup
set tempmail=
endlocal

echo .
echo .
echo PILOT - STOPPING LOCAL APPSERVERS...

call asbman -name EpicorPilot904ProcessServer -stop -port 20940

@echo off & setlocal
:: set the temp file location
set tempmail=%temp%\tempmail.%random%.txt
:: echo the basic headers to the temp file
echo To: "Backup Users" ^<backup.users@...^> > %tempmail%
echo From: "Epicor Daily Maintenance" ^<no-reply@...^> >> %tempmail%
echo Subject: EpicorPilot904ProcessServer has stopped successfully >> %tempmail%
:: echo the blank line that separates the header from the body text
echo.>>%tempmail%
:: echo the body text to the temp file
echo [DIAGNOSTIC MODE] The Epicor904ProcessServer has stopped successfully.>> %tempmail%
:: move the temp file to the mail pickup directory
:: adjust this location for your system
move %tempmail% C:\Inetpub\mailroot\Pickup
set tempmail=
endlocal

call asbman -name EpicorPilot904TaskAgent -stop -port 20940

@echo off & setlocal
:: set the temp file location
set tempmail=%temp%\tempmail.%random%.txt
:: echo the basic headers to the temp file
echo To: "Backup Users" ^<backup.users@...^> > %tempmail%
echo From: "Epicor Daily Maintenance" ^<no-reply@...^> >> %tempmail%
echo Subject: EpicorPilot904TaskAgent has stopped >> %tempmail%
:: echo the blank line that separates the header from the body text
echo.>>%tempmail%
:: echo the body text to the temp file
echo [DIAGNOSTIC MODE] The EpicorPilot904TaskAgent has stopped successfully.>> %tempmail%
:: move the temp file to the mail pickup directory
:: adjust this location for your system
move %tempmail% C:\Inetpub\mailroot\Pickup
set tempmail=
endlocal

call asbman -name EpicorPilot904 -stop -port 20940

@echo off & setlocal
:: set the temp file location
set tempmail=%temp%\tempmail.%random%.txt
:: echo the basic headers to the temp file
echo To: "Backup Users" ^<backup.users@...^> > %tempmail%
echo From: "Epicor Daily Maintenance" ^<no-reply@...^> >> %tempmail%
echo Subject: EpicorPilot904Appserver has stopped >> %tempmail%
:: echo the blank line that separates the header from the body text
echo.>>%tempmail%
:: echo the body text to the temp file
echo [DIAGNOSTIC MODE] The EpicorPilot904 Appserver has stopped successfully.>> %tempmail%
:: move the temp file to the mail pickup directory
:: adjust this location for your system
move %tempmail% C:\Inetpub\mailroot\Pickup
set tempmail=
endlocal

echo .
echo PILOT - STOPPING LOCAL DATABASE...

call dbman -host localhost -database EpicorPilot904 -stop -port 20940

@echo off & setlocal
:: set the temp file location
set tempmail=%temp%\tempmail.%random%.txt
:: echo the basic headers to the temp file
echo To: "Backup Users" ^<backup.users@...^> > %tempmail%
echo From: "Epicor Daily Maintenance" ^<no-reply@...^> >> %tempmail%
echo Subject: Epicor Pilot Database has stopped. >> %tempmail%
:: echo the blank line that separates the header from the body text
echo.>>%tempmail%
:: echo the body text to the temp file
echo [DIAGNOSTIC MODE] The Epicor Pilot Database has stopped successfully.>> %tempmail%
:: move the temp file to the mail pickup directory
:: adjust this location for your system
move %tempmail% C:\Inetpub\mailroot\Pickup
set tempmail=
endlocal

Â
:TestStopPilot
ECHO Testing Lock File
IF EXIST E:\epicor904\db\pilot\mfgsys.lk GOTO TestStopPilot

@echo off & setlocal
:: set the temp file location
set tempmail=%temp%\tempmail.%random%.txt
:: echo the basic headers to the temp file
echo To: "Backup Users" ^<backup.users@...^> > %tempmail%
echo From: "Epicor Daily Maintenance" ^<no-reply@...^> >> %tempmail%
echo Subject: Epicor Pilot Database and Appservers have stopped >> %tempmail%
:: echo the blank line that separates the header from the body text
echo.>>%tempmail%
:: echo the body text to the temp file
echo [DIAGNOSTIC MODE] The Epicor Pilot Database and Appservers have stopped successfully. Moving to Test.>> %tempmail%
:: move the temp file to the mail pickup directory
:: adjust this location for your system
move %tempmail% C:\Inetpub\mailroot\Pickup
set tempmail=
endlocal

echo .
echo .
echo TEST - STOPPING LOCAL APPSERVERS...

call asbman -name EpicorTest904TaskAgent -stop -port 20940

@echo off & setlocal
:: set the temp file location
set tempmail=%temp%\tempmail.%random%.txt
:: echo the basic headers to the temp file
echo To: "Backup Users" ^<backup.users@...^> > %tempmail%
echo From: "Epicor Daily Maintenance" ^<no-reply@...^> >> %tempmail%
echo Subject: EpicorTest904Taskagent has stopped >> %tempmail%
:: echo the blank line that separates the header from the body text
echo.>>%tempmail%
:: echo the body text to the temp file
echo [DIAGNOSTIC MODE] The EpicorTest904TaskAgent has stopped successfully.>> %tempmail%
:: move the temp file to the mail pickup directory
:: adjust this location for your system
move %tempmail% C:\Inetpub\mailroot\Pickup
set tempmail=
endlocal

call asbman -name EpicorTest904ProcessServer -stop -port 20940

@echo off & setlocal
:: set the temp file location
set tempmail=%temp%\tempmail.%random%.txt
:: echo the basic headers to the temp file
echo To: "Backup Users" ^<backup.users@...^> > %tempmail%
echo From: "Epicor Daily Maintenance" ^<no-reply@...^> >> %tempmail%
echo Subject: EpicorTest904ProcessServer has stopped >> %tempmail%
:: echo the blank line that separates the header from the body text
echo.>>%tempmail%
:: echo the body text to the temp file
echo [DIAGNOSTIC MODE] The EpicorTest904ProcessServer has stopped successfully.>> %tempmail%
:: move the temp file to the mail pickup directory
:: adjust this location for your system
move %tempmail% C:\Inetpub\mailroot\Pickup
set tempmail=
endlocal

call asbman -name EpicorTest904 -stop -port 20940

@echo off & setlocal
:: set the temp file location
set tempmail=%temp%\tempmail.%random%.txt
:: echo the basic headers to the temp file
echo To: "Backup Users" ^<backup.users@...^> > %tempmail%
echo From: "Epicor Daily Maintenance" ^<no-reply@...^> >> %tempmail%
echo Subject: EpicorTest904 Appserver has stopped >> %tempmail%
:: echo the blank line that separates the header from the body text
echo.>>%tempmail%
:: echo the body text to the temp file
echo [DIAGNOSTIC MODE] The EpicorTest904 Appserver has stopped successfully.>> %tempmail%
:: move the temp file to the mail pickup directory
:: adjust this location for your system
move %tempmail% C:\Inetpub\mailroot\Pickup
set tempmail=
endlocal

echo .
echo TEST - STOPPING LOCAL DATABASE...

call dbman -host localhost -database EpicorTest904 -stop -port 20940

@echo off & setlocal
:: set the temp file location
set tempmail=%temp%\tempmail.%random%.txt
:: echo the basic headers to the temp file
echo To: "Backup Users" ^<backup.users@...^> > %tempmail%
echo From: "Epicor Daily Maintenance" ^<no-reply@...^> >> %tempmail%
echo Subject: Epicor Test Database has stopped >> %tempmail%
:: echo the blank line that separates the header from the body text
echo.>>%tempmail%
:: echo the body text to the temp file
echo [DIAGNOSTIC MODE] The Epicor Test Database has stopped successfully.>> %tempmail%
:: move the temp file to the mail pickup directory
:: adjust this location for your system
move %tempmail% C:\Inetpub\mailroot\Pickup
set tempmail=
endlocal

Â
:TestStopTest
ECHO Testing Lock File
IF EXIST E:\epicor904\db\test\mfgsys.lk GOTO TestStopTest

@echo off & setlocal
:: set the temp file location
set tempmail=%temp%\tempmail.%random%.txt
:: echo the basic headers to the temp file
echo To: "Backup Users" ^<backup.users@...^> > %tempmail%
echo From: "Epicor Daily Maintenance" ^<no-reply@...^> >> %tempmail%
echo Subject: Epicor Test Database and Appservers have stopped successfully >> %tempmail%
:: echo the blank line that separates the header from the body text
echo.>>%tempmail%
:: echo the body text to the temp file
echo [DIAGNOSTIC MODE] The Epicor Test Database and Appservers have stopped successfully. Moving to Test.>> %tempmail%
:: move the temp file to the mail pickup directory
:: adjust this location for your system
move %tempmail% C:\Inetpub\mailroot\Pickup
set tempmail=
endlocal

echo .
echo .
echo TRAIN - STOPPING LOCAL APPSERVERS...

call asbman -name EpicorTrain904TaskAgent -stop -port 20940

@echo off & setlocal
:: set the temp file location
set tempmail=%temp%\tempmail.%random%.txt
:: echo the basic headers to the temp file
echo To: "Backup Users" ^<backup.users@...^> > %tempmail%
echo From: "Epicor Daily Maintenance" ^<no-reply@...^> >> %tempmail%
echo Subject: EpicorTrain904TaskAgen has stopped >> %tempmail%
:: echo the blank line that separates the header from the body text
echo.>>%tempmail%
:: echo the body text to the temp file
echo [DIAGNOSTIC MODE] The EpicorTrain904TaskAgent has stopped successfully.>> %tempmail%
:: move the temp file to the mail pickup directory
:: adjust this location for your system
move %tempmail% C:\Inetpub\mailroot\Pickup
set tempmail=
endlocal

call asbman -name EpicorTrain904ProcessServer -stop -port 20940

@echo off & setlocal
:: set the temp file location
set tempmail=%temp%\tempmail.%random%.txt
:: echo the basic headers to the temp file
echo To: "Backup Users" ^<backup.users@...^> > %tempmail%
echo From: "Epicor Daily Maintenance" ^<no-reply@...^> >> %tempmail%
echo Subject: EpicorTrain904ProcessServer has stopped >> %tempmail%
:: echo the blank line that separates the header from the body text
echo.>>%tempmail%
:: echo the body text to the temp file
echo [DIAGNOSTIC MODE] The EpicorTrain904ProcessServer has stopped successfully.>> %tempmail%
:: move the temp file to the mail pickup directory
:: adjust this location for your system
move %tempmail% C:\Inetpub\mailroot\Pickup
set tempmail=
endlocal

call asbman -name EpicorTrain904 -stop -port 20940

@echo off & setlocal
:: set the temp file location
set tempmail=%temp%\tempmail.%random%.txt
:: echo the basic headers to the temp file
echo To: "Backup Users" ^<backup.users@...^> > %tempmail%
echo From: "Epicor Daily Maintenance" ^<no-reply@...^> >> %tempmail%
echo Subject: EpicorTrain904 Appserver has stopeed >> %tempmail%
:: echo the blank line that separates the header from the body text
echo.>>%tempmail%
:: echo the body text to the temp file
echo [DIAGNOSTIC MODE] The EpicorTrain904 Appserver has stopped successfully.>> %tempmail%
:: move the temp file to the mail pickup directory
:: adjust this location for your system
move %tempmail% C:\Inetpub\mailroot\Pickup
set tempmail=
endlocal

echo .
echo TRAIN - STOPPING LOCAL DATABASE...

call dbman -host localhost -database EpicorTrain904 -stop -port 20940

@echo off & setlocal
:: set the temp file location
set tempmail=%temp%\tempmail.%random%.txt
:: echo the basic headers to the temp file
echo To: "Backup Users" ^<backup.users@...^> > %tempmail%
echo From: "Epicor Daily Maintenance" ^<no-reply@...^> >> %tempmail%
echo Subject: Epicor Train Database has stopped >> %tempmail%
:: echo the blank line that separates the header from the body text
echo.>>%tempmail%
:: echo the body text to the temp file
echo [DIAGNOSTIC MODE] The Epicor Train Database has stopped successfully.>> %tempmail%
:: move the temp file to the mail pickup directory
:: adjust this location for your system
move %tempmail% C:\Inetpub\mailroot\Pickup
set tempmail=
endlocal

Â
:TestStopTrain
ECHO Testing Lock File
IF EXIST E:\epicor904\db\pilot\train\mfgsys.lk GOTO TestStopTrain

@echo off & setlocal
:: set the temp file location
set tempmail=%temp%\tempmail.%random%.txt
:: echo the basic headers to the temp file
echo To: "Backup Users" ^<backup.users@...^> > %tempmail%
echo From: "Epicor Daily Maintenance" ^<no-reply@...^> >> %tempmail%
echo Subject: Epicor Pilot Database and Appservers have stopped >> %tempmail%
:: echo the blank line that separates the header from the body text
echo.>>%tempmail%
:: echo the body text to the temp file
echo [DIAGNOSTIC MODE] The Epicor Pilot Database and Appservers have stopped successfully. Moving to services and task killer.>> %tempmail%
:: move the temp file to the mail pickup directory
:: adjust this location for your system
move %tempmail% C:\Inetpub\mailroot\Pickup
set tempmail=
endlocal

echo .
echo EPICOR - STOPPING ADMIN SERVICE FOR OPEN EDGE

net stop "AdminService for OpenEdge 10.1C"

@echo off & setlocal
:: set the temp file location
set tempmail=%temp%\tempmail.%random%.txt
:: echo the basic headers to the temp file
echo To: "Backup Users" ^<backup.users@...^> > %tempmail%
echo From: "Epicor Daily Maintenance" ^<no-reply@...^> >> %tempmail%
echo Subject: The OpenEdge Service has stopped >> %tempmail%
:: echo the blank line that separates the header from the body text
echo.>>%tempmail%
:: echo the body text to the temp file
echo [DIAGNOSTIC MODE] The OpenEdge Service has stopped successfully. Stopping any rogue tasks.>> %tempmail%
:: move the temp file to the mail pickup directory
:: adjust this location for your system
move %tempmail% C:\Inetpub\mailroot\Pickup
set tempmail=
endlocal

TASKLIST > C:\TaskList_before.txt

TASKKILL /F /IM _proapsv.exe

TASKKILL /F /IM _mprosrv.exe

TASKLIST > C:\TaskList_after.txt

@echo off & setlocal
:: set the temp file location
set tempmail=%temp%\tempmail.%random%.txt
:: echo the basic headers to the temp file
echo To: "Backup Users" ^<backup.users@...^> > %tempmail%
echo From: "Epicor Daily Maintenance" ^<no-reply@...^> >> %tempmail%
echo Subject: All Database, Apps and Relevant Services are now stopped >> %tempmail%
:: echo the blank line that separates the header from the body text
echo.>>%tempmail%
:: echo the body text to the temp file
echo [DIAGNOSTIC MODE] The script 'stop_all_apps_and_service' has completed successfully. If you think these are an excessive amount of emails for your inbox: Please spare a thought for the poor soul who had to write them out individually.>> %tempmail%
:: move the temp file to the mail pickup directory
:: adjust this location for your system
move %tempmail% C:\Inetpub\mailroot\Pickup
set tempmail=
endlocal

psexec \\svrmail "D:\Data\Users\Office Documents\AutomaticSMS\automatic_sms_4.bat"

________________________________
From: adamnoffie <ygroups.adamleer@...>
To: vantage@yahoogroups.com
Sent: Monday, 13 May 2013, 13:48
Subject: [Vantage] Re: Epicor 9 Performance Issues

Â

Ted,

We had issues with our restart script hanging on the TaskAgent or the Print app servers. I think we have a working solution now, it is similar to what others have posted except it tries to kill the TaskAgent and the Print app servers simultaneously. This has better results for us.

REM --------------------------------------------
REM Re-start prod task/print/process app servers
REM --------------------------------------------

@echo off

set DLC=E:\Epicor\OE102A
set PATH=%DLC%\BIN;%PATH%
set LIB=%DLC%\LIB;%LIB%

echo Re-Stopping 9.05 Process, Task, Print app brokers
echo STOPPING LOCAL DB/APPSERVER...

call asbman -name Epicor905ProcessServer -stop
START cmd /c call asbman -name Epicor905TaskAgent -stop
call asbman -name Epicor905Print -stop

echo STARTING LOCAL DB/APPSERVER...

call asbman -name Epicor905Print -start
call asbman -name Epicor905TaskAgent -start
call asbman -name Epicor905ProcessServer -start

--- In vantage@yahoogroups.com, Ted Koch <tkoch77@...> wrote:
>
> Does anyone have an example of a batch file that would restart the appservers they could shared?
>
> Thanks!
>
>

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

system · May 13, 2013, 9:48am

Hi,

Do you really get away with running it only once a week?

We do it daily and we still encounter performance issues.

Wouldn't you have thought Epicor would sort out the software so we don't have to write these ourselves.

Thanks,

CHRIS

________________________________
From: Ted Koch <tkoch77@...>
To: "vantage@yahoogroups.com" <vantage@yahoogroups.com>
Sent: Monday, 13 May 2013, 14:08
Subject: Re: [Vantage] Re: Epicor 9 Performance Issues

Â
This is the batch file I ended up creating. I have it scheduled to run every Saturday night, works fine. Also, there is a parameter in the MfgSys.pf file -Bt. I changed the -Bt value from its default of 4096 to the maximum value 50,000. This appears to have helped with performance substantially according to users. I also made some other changes that are referenced in the Epicor Performance Tuning Guide, the settings you can use all depend on your hardware.

set DLC=F:\epicor\oe102a
F:
cd \epicor\oe102a\bin

call asbman -name Epicor905ProcessServer -stop
call asbman -name Epicor905TaskAgent -stop
call asbman -name Epicor905 -stop
REM call dbman -database Epicor905 -stop

ping 127.0.0.1 -n 30 -w 1000 > nul

REM call dbman -database Epicor905 -start
call asbman -name Epicor905 -start
call asbman -name Epicor905TaskAgent -start
call asbman -name Epicor905ProcessServer -start

________________________________
From: adamnoffie <ygroups.adamleer@...>
To: vantage@yahoogroups.com
Sent: Monday, May 13, 2013 8:48 AM
Subject: [Vantage] Re: Epicor 9 Performance Issues

Ted,

We had issues with our restart script hanging on the TaskAgent or the Print app servers.Â I think we have a working solution now, it is similar to what others have posted except it tries to kill the TaskAgent and the Print app servers simultaneously.Â This has better results for us.

REM --------------------------------------------
REM Re-start prod task/print/process app servers
REM --------------------------------------------

@echo off

set DLC=E:\Epicor\OE102A
set PATH=%DLC%\BIN;%PATH%
set LIB=%DLC%\LIB;%LIB%

echo Re-Stopping 9.05 Process, Task, Print app brokers
echo STOPPING LOCAL DB/APPSERVER...

call asbman -name Epicor905ProcessServer -stop
START cmd /c call asbman -name Epicor905TaskAgent -stop
call asbman -name Epicor905Print -stop

echo STARTING LOCAL DB/APPSERVER...

call asbman -name Epicor905Print -start
call asbman -name Epicor905TaskAgent -start
call asbman -name Epicor905ProcessServer -start

--- In vantage@yahoogroups.com, Ted Koch <tkoch77@...> wrote:
>
> Does anyone have an example of a batch file that would restart the appservers they could shared?
>
> Thanks!
>
>

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

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]

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

system · May 13, 2013, 9:56am

We just started restarting our AppServers every week about a month ago. It seems to be ok this way. Our database is 7.5GB in size.

________________________________
From: Chris Thompson <chriselectrix@...>
To: "vantage@yahoogroups.com" <vantage@yahoogroups.com>
Sent: Monday, May 13, 2013 9:48 AM
Subject: Re: [Vantage] Re: Epicor 9 Performance Issues

Hi,

Do you really get away with running it only once a week?

We do it daily and we still encounter performance issues.

Wouldn't you have thought Epicor would sort out the software so we don't have to write these ourselves.

Thanks,

CHRIS

________________________________
From: Ted Koch <tkoch77@...>
To: "vantage@yahoogroups.com" <vantage@yahoogroups.com>
Sent: Monday, 13 May 2013, 14:08
Subject: Re: [Vantage] Re: Epicor 9 Performance Issues

Â
This is the batch file I ended up creating. I have it scheduled to run every Saturday night, works fine. Also, there is a parameter in the MfgSys.pf file -Bt. I changed the -Bt value from its default of 4096 to the maximum value 50,000. This appears to have helped with performance substantially according to users. I also made some other changes that are referenced in the Epicor Performance Tuning Guide, the settings you can use all depend on your hardware.

set DLC=F:\epicor\oe102a
F:
cd \epicor\oe102a\bin

call asbman -name Epicor905ProcessServer -stop
call asbman -name Epicor905TaskAgent -stop
call asbman -name Epicor905 -stop
REM call dbman -database Epicor905 -stop

ping 127.0.0.1 -n 30 -w 1000 > nul

REM call dbman -database Epicor905 -start
call asbman -name Epicor905 -start
call asbman -name Epicor905TaskAgent -start
call asbman -name Epicor905ProcessServer -start

________________________________
From: adamnoffie <ygroups.adamleer@...>
To: vantage@yahoogroups.com
Sent: Monday, May 13, 2013 8:48 AM
Subject: [Vantage] Re: Epicor 9 Performance Issues

Ted,

We had issues with our restart script hanging on the TaskAgent or the Print app servers.Â I think we have a working solution now, it is similar to what others have posted except it tries to kill the TaskAgent and the Print app servers simultaneously.Â This has better results for us.

REM --------------------------------------------
REM Re-start prod task/print/process app servers
REM --------------------------------------------

@echo off

set DLC=E:\Epicor\OE102A
set PATH=%DLC%\BIN;%PATH%
set LIB=%DLC%\LIB;%LIB%

echo Re-Stopping 9.05 Process, Task, Print app brokers
echo STOPPING LOCAL DB/APPSERVER...

call asbman -name Epicor905ProcessServer -stop
START cmd /c call asbman -name Epicor905TaskAgent -stop
call asbman -name Epicor905Print -stop

echo STARTING LOCAL DB/APPSERVER...

call asbman -name Epicor905Print -start
call asbman -name Epicor905TaskAgent -start
call asbman -name Epicor905ProcessServer -start

--- In vantage@yahoogroups.com, Ted Koch <tkoch77@...> wrote:
>
> Does anyone have an example of a batch file that would restart the appservers they could shared?
>
> Thanks!
>
>

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

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]

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

system · May 13, 2013, 11:37am

Our DB is 16GB

________________________________
From: Ted Koch <tkoch77@...>
To: "vantage@yahoogroups.com" <vantage@yahoogroups.com>
Sent: Monday, 13 May 2013, 14:56
Subject: Re: [Vantage] Re: Epicor 9 Performance Issues

Â
We just started restarting our AppServers every week about a month ago. It seems to be ok this way. Our database is 7.5GB in size.

________________________________
From: Chris Thompson <chriselectrix@...>
To: "vantage@yahoogroups.com" <vantage@yahoogroups.com>
Sent: Monday, May 13, 2013 9:48 AM
Subject: Re: [Vantage] Re: Epicor 9 Performance Issues

Hi,

Do you really get away with running it only once a week?

We do it daily and we still encounter performance issues.

Wouldn't you have thought Epicor would sort out the software so we don't have to write these ourselves.

Thanks,

CHRIS

________________________________
From: Ted Koch <tkoch77@...>
To: "vantage@yahoogroups.com" <vantage@yahoogroups.com>
Sent: Monday, 13 May 2013, 14:08
Subject: Re: [Vantage] Re: Epicor 9 Performance Issues

Â
This is the batch file I ended up creating. I have it scheduled to run every Saturday night, works fine. Also, there is a parameter in the MfgSys.pf file -Bt. I changed the -Bt value from its default of 4096 to the maximum value 50,000. This appears to have helped with performance substantially according to users. I also made some other changes that are referenced in the Epicor Performance Tuning Guide, the settings you can use all depend on your hardware.

set DLC=F:\epicor\oe102a
F:
cd \epicor\oe102a\bin

call asbman -name Epicor905ProcessServer -stop
call asbman -name Epicor905TaskAgent -stop
call asbman -name Epicor905 -stop
REM call dbman -database Epicor905 -stop

ping 127.0.0.1 -n 30 -w 1000 > nul

REM call dbman -database Epicor905 -start
call asbman -name Epicor905 -start
call asbman -name Epicor905TaskAgent -start
call asbman -name Epicor905ProcessServer -start

________________________________
From: adamnoffie <ygroups.adamleer@...>
To: vantage@yahoogroups.com
Sent: Monday, May 13, 2013 8:48 AM
Subject: [Vantage] Re: Epicor 9 Performance Issues

Ted,

We had issues with our restart script hanging on the TaskAgent or the Print app servers.Â I think we have a working solution now, it is similar to what others have posted except it tries to kill the TaskAgent and the Print app servers simultaneously.Â This has better results for us.

REM --------------------------------------------
REM Re-start prod task/print/process app servers
REM --------------------------------------------

@echo off

set DLC=E:\Epicor\OE102A
set PATH=%DLC%\BIN;%PATH%
set LIB=%DLC%\LIB;%LIB%

echo Re-Stopping 9.05 Process, Task, Print app brokers
echo STOPPING LOCAL DB/APPSERVER...

call asbman -name Epicor905ProcessServer -stop
START cmd /c call asbman -name Epicor905TaskAgent -stop
call asbman -name Epicor905Print -stop

echo STARTING LOCAL DB/APPSERVER...

call asbman -name Epicor905Print -start
call asbman -name Epicor905TaskAgent -start
call asbman -name Epicor905ProcessServer -start

--- In vantage@yahoogroups.com, Ted Koch <tkoch77@...> wrote:
>
> Does anyone have an example of a batch file that would restart the appservers they could shared?
>
> Thanks!
>
>

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

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]

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

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

system · May 31, 2013, 2:20pm

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, Chris Thompson <chriselectrix@...> wrote:
>
> Do you regularly restart your apps and db?
>
>
>
>
> ________________________________
> From: mbarryjr1 <mikebarry@...>
> To: vantage@yahoogroups.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, 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
> > 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]
> >
>
>
>
>
> [Non-text portions of this message have been removed]
>

system · May 31, 2013, 2:34pm

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]

system · June 3, 2013, 7:23am

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

system · June 3, 2013, 7:40am

Do a few searches on the user group, I as well as others have posted quantified improvement on certain hardware.

Sent from my U.S. CellularÂ® Smartphone

-------- Original message --------
From: mseal <mseal@...>
Date: 06/03/2013 6:24 AM (GMT-06:00)
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Epicor 9 Performance Issues

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

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

system · June 3, 2013, 8:35am

I can't quantify in precise numbers are you looking at the client performance measurable?, I'm moving from 6.1 to 9, I did a bit of a custom install on the server, my Dell R810 has 2 SSD's and 2 spindle drives, I boot from the SSD's and have the my progress database on the SSD's. Everything else on the spindle drives. I can reboot my server in 1 minute, also Windows patches and progress patches install extremely fast also, also it's simpler from an administration stand point meaning 1 pair of SSDs Several parts of spindle drives to spread the database across. Notice I have not yet mentioned anything about end user performance. I'm seeing better performance than my Vantage 6.1 installation and didn't think I would ever see that. Dell shows 6 - 15K 300gb drives for around $2200, you can get 2 SSD's for $2300. Remember to get SLC not MLC. My DB is 10gb, 50 users, 20 data collection. I'm not a back end server, DB, hardware expert but SSDs make me look like one.

Hope this helps.

Patrick Winter

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of mseal
Sent: Monday, June 03, 2013 06:24
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Epicor 9 Performance Issues

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 <mailto:vantage%40yahoogroups.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%40yahoogroups.com> [mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On Behalf Of JEFFBOLL
> Sent: Friday, May 31, 2013 13:21
> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.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> <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> <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> <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> <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]
> > >
> >
> >
> >
> >
> > [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]

system · June 3, 2013, 10:15am

Motty,

When we switched over to Intel 910 SSD cards... the best way to quantify our improvement was with how long MRP takes to run.

For full regen, no finite scheduling.

Before 14 hours.
Now under 8 hours.

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 mseal
Sent: Monday, June 03, 2013 4:24 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Epicor 9 Performance Issues

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<mailto:vantage%40yahoogroups.com>, "Winter, Patrick" <pjw@...<mailto: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%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf Of JEFFBOLL
> Sent: Friday, May 31, 2013 13:21
> To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.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> <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> <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> <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> <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]
> > >
> >
> >
> >
> >
> > [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]

system · June 3, 2013, 2:07pm

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

system · June 4, 2013, 7:00am

This question has been answered 14556754 times. Look through the list

On Jun 3, 2013 4:49 PM, "mikethorne1980" <mikethorne1980@...> wrote:

> **
>
>
> Joining the bandwagon as well. VERY curious if SSD on the servers has any
> performance increases. Was told it would at a user conference, but I would
> like solid proof to make the case to management.
>
> --- 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]
> > >
> >
>
>
>

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

system · June 4, 2013, 10:09am

I have ssds on desktops and pci express ssd for database and yes it makes a difference decrease MRP runtime, However for day to day operations such as order entry having multiple appservers has made the biggest difference. We have 80 users, 12 handhelds and 7 MES. We run appservers in a virtual environment with a physical load balancer by Kemp. Right now we have three app servers.

--- In vantage@yahoogroups.com, Jose Gomez <jose@...> wrote:
>
> This question has been answered 14556754 times. Look through the list
> On Jun 3, 2013 4:49 PM, "mikethorne1980" <mikethorne1980@...> wrote:
>
> > **
> >
> >
> > Joining the bandwagon as well. VERY curious if SSD on the servers has any
> > performance increases. Was told it would at a user conference, but I would
> > like solid proof to make the case to management.
> >
> > --- 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]
> > > >
> > >
> >
> >
> >
>
>
> [Non-text portions of this message have been removed]
>

system · June 4, 2013, 10:13am

As someone else mentioned, I can't quantify it with actual numbers for you,
but from my experience with doing many many different installations on SANs,
Fusion I/O, NAS, DAS, SSD, and 15K drives, the best option with the best
performance has always been SSD drives in the server itself, RAID 1, no need
for RAID 1+0 unless you buy smaller drives and need the total space that 1+0
gives you.

This is especially true if you are running SQL.

Here's the caveat though, every single person's system is different,
everyone uses the system a little differently, with different database
contents, this will alter how much the change from one to the other is in
terms of noticeability.

There have been instances where I have seen zero change, but that is because
the speed of the system and the demand on the system hadn't reached the
point where it was beyond what their standard 15K SAS could handle. This is
not the typical results going to SSD though, normally there is a noticeable
improvement. Especially with anything that is heavily disk intensive, as
someone pointed out before, MRP will usually kick up a notch, anywhere from
25-40% in run time speed.

You will see improvement more when you have SSD in the server than on the
clients in my opinion.

Also... since we are talking about performance... one thing that I have seen
tested with some anecdotel success if for people with tons of excess RAM in
their servers, putting the Temp directory in a RAM Drive.

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
mikethorne1980
Sent: Monday, June 03, 2013 4:49 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Epicor 9 Performance Issues

Joining the bandwagon as well. VERY curious if SSD on the servers has any
performance increases. Was told it would at a user conference, but I would
like solid proof to make the case to management.

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

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

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

Topic		Replies	Views
Epicor 9 Impossibly slow Yahoo Archive	25	1893	August 10, 2010
Epicor 9 Dump & Loads Yahoo Archive	5	439	March 26, 2010
Upgrade to Epicor 9 from v4.4 Yahoo Archive	3	435	March 25, 2009
Vantage 8 to Epicor 9 - need feedback Yahoo Archive	2	452	November 16, 2011
Is moving to Epicor 9 worth the effort? Yahoo Archive	4	372	January 29, 2010

Epicor 9 Performance Issues

Related Topics