Sudden Performance Slowdown - E9 SQL Environment

Yahoo Archive
1
None since then, still at 504C. I regularly clean out the folders but let me look again

--- On Mon, 3/29/10, Ned <TechnoBabbly@...> wrote:


From: Ned <TechnoBabbly@...>
Subject: Re: [Vantage] Sudden Performance Slowdown - E9 SQL Environment
To: vantage@yahoogroups.com
Date: Monday, March 29, 2010, 12:46 PM


Â



How many service packs have you put on since then?

Any thought that excess folders in the C:\Documents and Settings\All
Users\Application Data\Epicor directory might be causing some slowdown when
it kicks up?

----- Original Message -----
From: "Mark Wagner" <mjfw2003@yahoo. com>
To: "Vantage User Group" <vantage@yahoogroups .com>
Sent: Monday, March 29, 2010 7:57 AM
Subject: [Vantage] Sudden Performance Slowdown - E9 SQL Environment

After running well for about 9 months, Banner screen now takes about 16
seconds to appear and another 10 seconds for system monitor. This is logging
in right on the server with no users logged on.

Ran Disable Locking on SQL 2005. Progress Databases are set to read only.
Only thing added last several weeks was Indexing, mainly to do Case Entry
boolean searches

Anyone else see something similar and what might be causing? Log files from
server and SQL sent to Epicor, nothing obvious at this point

[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]
2
After running well for about 9 months, Banner screen now takes about 16 seconds to appear and another 10 seconds for system monitor. This is logging in right on the server with no users logged on.
Â
Ran Disable Locking on SQL 2005. Progress Databases are set to read only. Only thing added last several weeks was Indexing, mainly to do Case Entry boolean searches
Â
Anyone else see something similar and what might be causing? Log files from server and SQL sent to Epicor, nothing obvious at this point




[Non-text portions of this message have been removed]
3
We are not on E9, but 8.03.408B SQL....we notice
a similar phenomena and associate it with a "runaway APP Server".

We delete the abandoned App server(s) and
everything returns to normal response time.

Our first telltale in IT is a watch we keep on
the % resources being used on each core of the
server. We have the equipment pretty well
calibrated and know when the Task Manager
Schedule drives the usage up. If we see a core
at 100% and it's staying there we look through
Task manager processes for an abandoned App
server. The App server associated with the core
is usually the orphan. We check the PID's of all
app servers to confirm that the suspect is in
fact detached from Open Edge. We then delete the
orphaned PID/App server using Task Manager.

If left unattended the whole system gradually grinds to a halt.

Happens about once every 5 or 6 weeks.



At 07:57 AM 3/29/2010, you wrote:
>
>
>After running well for about 9 months, Banner
>screen now takes about 16 seconds to appear and
>another 10 seconds for system monitor. This is
>logging in right on the server with no users logged on.
>
>Ran Disable Locking on SQL 2005. Progress
>Databases are set to read only. Only thing
>added last several weeks was Indexing, mainly to do Case Entry boolean searches
>
>Anyone else see something similar and what might
>be causing? Log files from server and SQL sent
>to Epicor, nothing obvious at this point
>
>[Non-text portions of this message have been removed]
>
>



[Non-text portions of this message have been removed]
4
I stop and start my Vantage processserver and taskagent appservers nightly.

e.g.

@echo off
set DLC=C:\Epicor\OE101B
set PATH=%DLC%\BIN;%PATH%
set LIB=%DLC%\LIB;%LIB%
rem C:
echo .
echo .
echo STOPPING MfgSys803 ProcessServer and TaskAgent...
rem cd \Epicor\MfgSys803\db
call asbman -name MfgSys803ProcessServer -stop
call asbman -name MfgSys803TaskAgent -stop

I don't restart the main appserver, but you could do this as well. Be sure you schedule this so it doesn't interfere with nightly scheduled tasks (e.g. MRP).

-bws

--
Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix / Picometrix
    bspolarich@... ~ 734-864-5618 ~ www.advancedphotonix.com


-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Robert Carlson
Sent: Monday, March 29, 2010 11:19 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Sudden Performance Slowdown - E9 SQL Environment

We are not on E9, but 8.03.408B SQL....we notice
a similar phenomena and associate it with a "runaway APP Server".

We delete the abandoned App server(s) and
everything returns to normal response time.

Our first telltale in IT is a watch we keep on
the % resources being used on each core of the
server. We have the equipment pretty well
calibrated and know when the Task Manager
Schedule drives the usage up. If we see a core
at 100% and it's staying there we look through
Task manager processes for an abandoned App
server. The App server associated with the core
is usually the orphan. We check the PID's of all
app servers to confirm that the suspect is in
fact detached from Open Edge. We then delete the
orphaned PID/App server using Task Manager.

If left unattended the whole system gradually grinds to a halt.

Happens about once every 5 or 6 weeks.



At 07:57 AM 3/29/2010, you wrote:
>
>
>After running well for about 9 months, Banner
>screen now takes about 16 seconds to appear and
>another 10 seconds for system monitor. This is
>logging in right on the server with no users logged on.
>
>Ran Disable Locking on SQL 2005. Progress
>Databases are set to read only. Only thing
>added last several weeks was Indexing, mainly to do Case Entry boolean searches
>
>Anyone else see something similar and what might
>be causing? Log files from server and SQL sent
>to Epicor, nothing obvious at this point
>
>[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
5
Thanks Rob, this is what I suspected, but could not confirm, all along. How do you know if there is an "orphan" app server?

--- On Mon, 3/29/10, Robert Carlson <rcarlson@...> wrote:


From: Robert Carlson <rcarlson@...>
Subject: Re: [Vantage] Sudden Performance Slowdown - E9 SQL Environment
To: vantage@yahoogroups.com
Date: Monday, March 29, 2010, 11:18 AM


Â



We are not on E9, but 8.03.408B SQL....we notice
a similar phenomena and associate it with a "runaway APP Server".

We delete the abandoned App server(s) and
everything returns to normal response time.

Our first telltale in IT is a watch we keep on
the % resources being used on each core of the
server. We have the equipment pretty well
calibrated and know when the Task Manager
Schedule drives the usage up. If we see a core
at 100% and it's staying there we look through
Task manager processes for an abandoned App
server. The App server associated with the core
is usually the orphan. We check the PID's of all
app servers to confirm that the suspect is in
fact detached from Open Edge. We then delete the
orphaned PID/App server using Task Manager.

If left unattended the whole system gradually grinds to a halt.

Happens about once every 5 or 6 weeks.

At 07:57 AM 3/29/2010, you wrote:
>
>
>After running well for about 9 months, Banner
>screen now takes about 16 seconds to appear and
>another 10 seconds for system monitor. This is
>logging in right on the server with no users logged on.
>
>Ran Disable Locking on SQL 2005. Progress
>Databases are set to read only. Only thing
>added last several weeks was Indexing, mainly to do Case Entry boolean searches
>
>Anyone else see something similar and what might
>be causing? Log files from server and SQL sent
>to Epicor, nothing obvious at this point
>
>[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]
6
Thanks Brian. I've been starting and stopping, sometimes multiple times a day. Have even done a hard shut down and no difference. Have you also seen where an appserver will not shut down without killing the process?

--- On Mon, 3/29/10, Brian W. Spolarich <bspolarich@...> wrote:


From: Brian W. Spolarich <bspolarich@...>
Subject: RE: [Vantage] Sudden Performance Slowdown - E9 SQL Environment
To: vantage@yahoogroups.com
Date: Monday, March 29, 2010, 11:23 AM


Â



I stop and start my Vantage processserver and taskagent appservers nightly.

e.g.

@echo off
set DLC=C:\Epicor\ OE101B
set PATH=%DLC%\BIN; %PATH%
set LIB=%DLC%\LIB; %LIB%
rem C:
echo .
echo .
echo STOPPING MfgSys803 ProcessServer and TaskAgent...
rem cd \Epicor\MfgSys803\ db
call asbman -name MfgSys803ProcessSer ver -stop
call asbman -name MfgSys803TaskAgent -stop

I don't restart the main appserver, but you could do this as well. Be sure you schedule this so it doesn't interfere with nightly scheduled tasks (e.g. MRP).

-bws

--
Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix / Picometrix
    bspolarich@advanced photonix. com ~ 734-864-5618 ~ www.advancedphotoni x.com

-----Original Message-----
From: vantage@yahoogroups .com [mailto:vantage@yahoogroups .com] On Behalf Of Robert Carlson
Sent: Monday, March 29, 2010 11:19 AM
To: vantage@yahoogroups .com
Subject: Re: [Vantage] Sudden Performance Slowdown - E9 SQL Environment

We are not on E9, but 8.03.408B SQL....we notice
a similar phenomena and associate it with a "runaway APP Server".

We delete the abandoned App server(s) and
everything returns to normal response time.

Our first telltale in IT is a watch we keep on
the % resources being used on each core of the
server. We have the equipment pretty well
calibrated and know when the Task Manager
Schedule drives the usage up. If we see a core
at 100% and it's staying there we look through
Task manager processes for an abandoned App
server. The App server associated with the core
is usually the orphan. We check the PID's of all
app servers to confirm that the suspect is in
fact detached from Open Edge. We then delete the
orphaned PID/App server using Task Manager.

If left unattended the whole system gradually grinds to a halt.

Happens about once every 5 or 6 weeks.

At 07:57 AM 3/29/2010, you wrote:
>
>
>After running well for about 9 months, Banner
>screen now takes about 16 seconds to appear and
>another 10 seconds for system monitor. This is
>logging in right on the server with no users logged on.
>
>Ran Disable Locking on SQL 2005. Progress
>Databases are set to read only. Only thing
>added last several weeks was Indexing, mainly to do Case Entry boolean searches
>
>Anyone else see something similar and what might
>be causing? Log files from server and SQL sent
>to Epicor, nothing obvious at this point
>
>[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]
7
Occasionally.

--
Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix / Picometrix
    bspolarich@... ~ 734-864-5618 ~ www.advancedphotonix.com


-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Mark Wagner
Sent: Monday, March 29, 2010 11:47 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Sudden Performance Slowdown - E9 SQL Environment

Thanks Brian. I've been starting and stopping, sometimes multiple times a day. Have even done a hard shut down and no difference. Have you also seen where an appserver will not shut down without killing the process?

--- On Mon, 3/29/10, Brian W. Spolarich <bspolarich@...> wrote:


From: Brian W. Spolarich <bspolarich@...>
Subject: RE: [Vantage] Sudden Performance Slowdown - E9 SQL Environment
To: vantage@yahoogroups.com
Date: Monday, March 29, 2010, 11:23 AM


Â



I stop and start my Vantage processserver and taskagent appservers nightly.

e.g.

@echo off
set DLC=C:\Epicor\ OE101B
set PATH=%DLC%\BIN; %PATH%
set LIB=%DLC%\LIB; %LIB%
rem C:
echo .
echo .
echo STOPPING MfgSys803 ProcessServer and TaskAgent...
rem cd \Epicor\MfgSys803\ db
call asbman -name MfgSys803ProcessSer ver -stop
call asbman -name MfgSys803TaskAgent -stop

I don't restart the main appserver, but you could do this as well. Be sure you schedule this so it doesn't interfere with nightly scheduled tasks (e.g. MRP).

-bws

--
Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix / Picometrix
    bspolarich@advanced photonix. com ~ 734-864-5618 ~ www.advancedphotoni x.com

-----Original Message-----
From: vantage@yahoogroups .com [mailto:vantage@yahoogroups .com] On Behalf Of Robert Carlson
Sent: Monday, March 29, 2010 11:19 AM
To: vantage@yahoogroups .com
Subject: Re: [Vantage] Sudden Performance Slowdown - E9 SQL Environment

We are not on E9, but 8.03.408B SQL....we notice
a similar phenomena and associate it with a "runaway APP Server".

We delete the abandoned App server(s) and
everything returns to normal response time.

Our first telltale in IT is a watch we keep on
the % resources being used on each core of the
server. We have the equipment pretty well
calibrated and know when the Task Manager
Schedule drives the usage up. If we see a core
at 100% and it's staying there we look through
Task manager processes for an abandoned App
server. The App server associated with the core
is usually the orphan. We check the PID's of all
app servers to confirm that the suspect is in
fact detached from Open Edge. We then delete the
orphaned PID/App server using Task Manager.

If left unattended the whole system gradually grinds to a halt.

Happens about once every 5 or 6 weeks.

At 07:57 AM 3/29/2010, you wrote:
>
>
>After running well for about 9 months, Banner
>screen now takes about 16 seconds to appear and
>another 10 seconds for system monitor. This is
>logging in right on the server with no users logged on.
>
>Ran Disable Locking on SQL 2005. Progress
>Databases are set to read only. Only thing
>added last several weeks was Indexing, mainly to do Case Entry boolean searches
>
>Anyone else see something similar and what might
>be causing? Log files from server and SQL sent
>to Epicor, nothing obvious at this point
>
>[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]



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

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
8
How many service packs have you put on since then?

Any thought that excess folders in the C:\Documents and Settings\All
Users\Application Data\Epicor directory might be causing some slowdown when
it kicks up?


----- Original Message -----
From: "Mark Wagner" <mjfw2003@...>
To: "Vantage User Group" <vantage@yahoogroups.com>
Sent: Monday, March 29, 2010 7:57 AM
Subject: [Vantage] Sudden Performance Slowdown - E9 SQL Environment


After running well for about 9 months, Banner screen now takes about 16
seconds to appear and another 10 seconds for system monitor. This is logging
in right on the server with no users logged on.

Ran Disable Locking on SQL 2005. Progress Databases are set to read only.
Only thing added last several weeks was Indexing, mainly to do Case Entry
boolean searches

Anyone else see something similar and what might be causing? Log files from
server and SQL sent to Epicor, nothing obvious at this point




[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