Not Live Yet 9.05.702 - Server Running Slow - Rebooted now Fast?

Yahoo Archive
1
Thanks Calvin,



So far restarting the app servers really helped, after I'm under more of
a full load I was planning on using the Performance Diagnostic Tool.



Patrick Winter



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Calvin Dekker
Sent: Thursday, July 25, 2013 13:43
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Not Live Yet 9.05.702 - Server Running Slow -
Rebooted now Fast? Where do I look to monitor this?





Pat -

There is also a Performance Diagnostic Tool from Epicor. This tool
nicely analyzes the server log files to point you in the direction of
slow running processes quickly.

Thank you in advance,
Calvin Dekker
Office: 630-672-7688 Ext. 1484
Email: calvin@... <mailto:calvin%40codabears.com>
<mailto:calvin@... <mailto:calvin%40codabears.com> >
http://www.codabears.com<http://www.codabears.com/>
[cid:image001.jpg@...6C0
<mailto:image001.jpg%4001CE893C.DFCBC6C0> ]<http://www.codabears.com/>

Solutions for Epiday living.

"No trees were harmed during the sending of this message, however a
large number of electrons were terribly inconvenienced."

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of Winter, Patrick
Sent: Thursday, July 25, 2013 10:33 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Not Live Yet 9.05.702 - Server Running Slow -
Rebooted now Fast? Where do I look to monitor this?

Thx

Patrick Winter

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, July 25, 2013 09:08
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: Re: [Vantage] Not Live Yet 9.05.702 - Server Running Slow -
Rebooted now Fast? Where do I look to monitor this?

Epicor provides a performance tuning guide that might be worth taking a
look at.

Progress:
https://epicweb.epicor.com/doc/Docs/trPerformanceTuningProgress_905701.p
df

SQL:
https://epicweb.epicor.com/doc/Docs/TechRef_PerformanceTuningSQL_905702.
pdf

________________________________
From: "Winter, Patrick" <pjw@...
<mailto:pjw%40specialtyscrew.com> <mailto:pjw%40specialtyscrew.com>
<mailto:pjw%40specialtyscrew.com> >
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
Sent: Thursday, July 25, 2013 9:41 AM
Subject: [Vantage] Not Live Yet 9.05.702 - Server Running Slow -
Rebooted now Fast? Where do I look to monitor this?

Investigated a user complaint on Job Number V056500 that it took over 3
minutes to RETRIEVE on the MFg Receipts Tab.
I looked at the server as saw a bunch of Java.exe process growing and my
server CPU at 60% which seems kind of crazy on a new server with just 3
or 4 users logged in.

I killed some of the Java.exe sessions which was not very bright.
Rebooted the server and now performance is good.
The job retrieved the Mfg Receipts record in 18 seconds. Server
typically sits at 1% CPU Utilization not 60%.

Where should I look?
Do I need to restart the app servers once and a while? Just some or All?

All comments welcome.

9.05.702, Progress Database 8gb, 40 office, 20 shop users, lots of BAQ
Dashboards and BAQ Reports to Crystal.
Server Dell R810 - 32GB RAM, 2- Xeon X6550 2ghz, 18m cache, 8Core; 2
-200gb SSD, 2-146gb 15K SCSI

[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/>
<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]
2
Investigated a user complaint on Job Number V056500 that it took over 3
minutes to RETRIEVE on the MFg Receipts Tab.
I looked at the server as saw a bunch of Java.exe process growing and my
server CPU at 60% which seems kind of crazy on a new server with just 3
or 4 users logged in.

I killed some of the Java.exe sessions which was not very bright.
Rebooted the server and now performance is good.
The job retrieved the Mfg Receipts record in 18 seconds. Server
typically sits at 1% CPU Utilization not 60%.

Where should I look?
Do I need to restart the app servers once and a while? Just some or All?

All comments welcome.

9.05.702, Progress Database 8gb, 40 office, 20 shop users, lots of BAQ
Dashboards and BAQ Reports to Crystal.
Server Dell R810 - 32GB RAM, 2- Xeon X6550 2ghz, 18m cache, 8Core; 2
-200gb SSD, 2-146gb 15K SCSI



[Non-text portions of this message have been removed]
3
You should have a scheduled task to recycle your Appservers weekly,
This doesn't need to be a full server restart, you can utilise a script with asbman as the command to lookup.


From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Winter, Patrick
Sent: 25 July 2013 14:41
To: vantage@yahoogroups.com
Subject: [Vantage] Not Live Yet 9.05.702 - Server Running Slow - Rebooted now Fast? Where do I look to monitor this?



Investigated a user complaint on Job Number V056500 that it took over 3
minutes to RETRIEVE on the MFg Receipts Tab.
I looked at the server as saw a bunch of Java.exe process growing and my
server CPU at 60% which seems kind of crazy on a new server with just 3
or 4 users logged in.

I killed some of the Java.exe sessions which was not very bright.
Rebooted the server and now performance is good.
The job retrieved the Mfg Receipts record in 18 seconds. Server
typically sits at 1% CPU Utilization not 60%.

Where should I look?
Do I need to restart the app servers once and a while? Just some or All?

All comments welcome.

9.05.702, Progress Database 8gb, 40 office, 20 shop users, lots of BAQ
Dashboards and BAQ Reports to Crystal.
Server Dell R810 - 32GB RAM, 2- Xeon X6550 2ghz, 18m cache, 8Core; 2
-200gb SSD, 2-146gb 15K SCSI

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



[Non-text portions of this message have been removed]
4
Epicor provides a performance tuning guide that might be worth taking a look at.

Progress:
https://epicweb.epicor.com/doc/Docs/trPerformanceTuningProgress_905701.pdf

SQL:
https://epicweb.epicor.com/doc/Docs/TechRef_PerformanceTuningSQL_905702.pdf




________________________________
From: "Winter, Patrick" <pjw@...>
To: vantage@yahoogroups.com
Sent: Thursday, July 25, 2013 9:41 AM
Subject: [Vantage] Not Live Yet 9.05.702 - Server Running Slow - Rebooted now Fast? Where do I look to monitor this?


Investigated a user complaint on Job Number V056500 that it took over 3
minutes to RETRIEVE on the MFg Receipts Tab.Â
I looked at the server as saw a bunch of Java.exe process growing and my
server CPU at 60% which seems kind of crazy on a new server with just 3
or 4 users logged in.

I killed some of the Java.exe sessions which was not very bright.
Rebooted the server and now performance is good.
The job retrieved the Mfg Receipts record in 18 seconds. Server
typically sits at 1% CPU Utilization not 60%.

Where should I look?
Do I need to restart the app servers once and a while? Just some or All?

All comments welcome.

9.05.702, Progress Database 8gb, 40 office, 20 shop users, lots of BAQ
Dashboards and BAQ Reports to Crystal.
Server Dell R810 - 32GB RAM, 2- Xeon X6550 2ghz, 18m cache, 8Core; 2
-200gb SSD, 2-146gb 15K SCSI



[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]
5
The java.exe are your brokers which are running your _proapsvr instances.

If you download the Process Explorer from Microsoft, formerly Sysinternals,
then you can see the hierarchy of the processes.



-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Winter, Patrick
Sent: Thursday, July 25, 2013 9:41 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Not Live Yet 9.05.702 - Server Running Slow - Rebooted
now Fast? Where do I look to monitor this?

Investigated a user complaint on Job Number V056500 that it took over 3
minutes to RETRIEVE on the MFg Receipts Tab.
I looked at the server as saw a bunch of Java.exe process growing and my
server CPU at 60% which seems kind of crazy on a new server with just 3 or 4
users logged in.

I killed some of the Java.exe sessions which was not very bright.
Rebooted the server and now performance is good.
The job retrieved the Mfg Receipts record in 18 seconds. Server typically
sits at 1% CPU Utilization not 60%.

Where should I look?
Do I need to restart the app servers once and a while? Just some or All?

All comments welcome.

9.05.702, Progress Database 8gb, 40 office, 20 shop users, lots of BAQ
Dashboards and BAQ Reports to Crystal.
Server Dell R810 - 32GB RAM, 2- Xeon X6550 2ghz, 18m cache, 8Core; 2 -200gb
SSD, 2-146gb 15K SCSI



[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
6
So to further delve into things...

What is the distribution of your disks for use? What's installed where?
What do your .pf files look like? What about your settings in openedge for
the db?

Have you gone through the performance tuning document yet?


-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Winter, Patrick
Sent: Thursday, July 25, 2013 9:41 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Not Live Yet 9.05.702 - Server Running Slow - Rebooted
now Fast? Where do I look to monitor this?

Investigated a user complaint on Job Number V056500 that it took over 3
minutes to RETRIEVE on the MFg Receipts Tab.
I looked at the server as saw a bunch of Java.exe process growing and my
server CPU at 60% which seems kind of crazy on a new server with just 3 or 4
users logged in.

I killed some of the Java.exe sessions which was not very bright.
Rebooted the server and now performance is good.
The job retrieved the Mfg Receipts record in 18 seconds. Server typically
sits at 1% CPU Utilization not 60%.

Where should I look?
Do I need to restart the app servers once and a while? Just some or All?

All comments welcome.

9.05.702, Progress Database 8gb, 40 office, 20 shop users, lots of BAQ
Dashboards and BAQ Reports to Crystal.
Server Dell R810 - 32GB RAM, 2- Xeon X6550 2ghz, 18m cache, 8Core; 2 -200gb
SSD, 2-146gb 15K SCSI



[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
7
Operating system, database, embedded education on SSDs everything else
on SCSI





Patrick Winter



Thu Jul 25 08:05:42 2013

[2013/07/25@08:05:42.787-0500] P-988 T-5276 I BROKER 0: (333)
Multi-user session begin.

[2013/07/25@08:05:42.790-0500] P-988 T-5276 I BROKER 0: (5326)
Begin Physical Redo Phase at 12288 .

[2013/07/25@08:05:44.082-0500] P-988 T-5276 I BROKER 0: (7161)
Physical Redo Phase Completed at blk 1448 off 12256 upd 4658.

[2013/07/25@08:05:44.083-0500] P-988 T-5276 I BROKER 0: (13547)
At end of Physical redo, transaction table size is 512.

[2013/07/25@08:05:44.282-0500] P-988 T-5276 I BROKER 0: (452)
Login by SYSTEM on batch.

[2013/07/25@08:05:44.286-0500] P-988 T-5276 I BROKER 0: (5644)
Started for 9450 using TCP IPV4 address 0.0.0.0, pid 988.

[2013/07/25@08:05:44.287-0500] P-988 T-5276 I BROKER 0: (8836)
Connecting to Admin Server on port 7841.

[2013/07/25@08:05:44.290-0500] P-988 T-5276 I BROKER 0: (14262)
Successfully connected to AdminServer on port 7841 using TCP/IP IPV4
address 195.1.1.25.

[2013/07/25@08:05:44.293-0500] P-988 T-5276 I BROKER 0: (8846)
Registered with Admin Server.

[2013/07/25@08:05:44.294-0500] P-988 T-5276 I BROKER 0: (4234)
Progress OpenEdge Release 10.2A build 1390 SP03 TF29 on WINNT .

[2013/07/25@08:05:44.294-0500] P-988 T-5276 I BROKER 0: (4281)
Server started by SYSTEM on batch.

[2013/07/25@08:05:44.294-0500] P-988 T-5276 I BROKER 0: (6574)
Started using pid: 988.

[2013/07/25@08:05:44.295-0500] P-988 T-5276 I BROKER 0: (4235)
Physical Database Name (-db): E:\Epicor\db\mfgsys.

[2013/07/25@08:05:44.295-0500] P-988 T-5276 I BROKER 0: (4236)
Database Type (-dt): PROGRESS.

[2013/07/25@08:05:44.296-0500] P-988 T-5276 I BROKER 0: (4237)
Force Access (-F): Not Enabled.

[2013/07/25@08:05:44.296-0500] P-988 T-5276 I BROKER 0: (4238)
Direct I/O (-directio): Not Enabled.

[2013/07/25@08:05:44.296-0500] P-988 T-5276 I BROKER 0: (-----)
LRU mechanism enabled.

[2013/07/25@08:05:44.297-0500] P-988 T-5276 I BROKER 0: (4239)
Number of Database Buffers (-B): 700000.

[2013/07/25@08:05:44.297-0500] P-988 T-5276 I BROKER 0: (9422)
Maximum private buffers per user (-Bpmax): 64.

[2013/07/25@08:05:44.297-0500] P-988 T-5276 I BROKER 0: (4240)
Excess Shared Memory Size (-Mxs): 133.

[2013/07/25@08:05:44.298-0500] P-988 T-5276 I BROKER 0: (10014)
The shared memory segment is not locked in memory.

[2013/07/25@08:05:44.298-0500] P-988 T-5276 I BROKER 0: (4241)
Current Size of Lock Table (-L): 512000.

[2013/07/25@08:05:44.298-0500] P-988 T-5276 I BROKER 0: (13953)
Maximum Area Number (-maxArea): 32000.

[2013/07/25@08:05:44.299-0500] P-988 T-5276 I BROKER 0: (4242)
Hash Table Entries (-hash): 192877.

[2013/07/25@08:05:44.299-0500] P-988 T-5276 I BROKER 0: (4243)
Current Spin Lock Tries (-spin): 50000.

[2013/07/25@08:05:44.299-0500] P-988 T-5276 I BROKER 0: (6526)
Number of Semaphore Sets (-semsets): 3.

[2013/07/25@08:05:44.300-0500] P-988 T-5276 I BROKER 0: (13924)
Maximum Shared Memory Segment Size (-shmsegsize) 4096 Mb.

[2013/07/25@08:05:44.300-0500] P-988 T-5276 I BROKER 0: (4244)
Crash Recovery (-i): Enabled.

[2013/07/25@08:05:44.300-0500] P-988 T-5276 I BROKER 0: (6573)
Database Blocksize (-blocksize): 4096.

[2013/07/25@08:05:44.301-0500] P-988 T-5276 I BROKER 0: (4245)
Delay of Before-Image Flush (-Mf): 3.

[2013/07/25@08:05:44.301-0500] P-988 T-5276 I BROKER 0: (4247)
Before-Image File I/O (-r -R): Reliable.

[2013/07/25@08:05:44.301-0500] P-988 T-5276 I BROKER 0: (4249)
Before-Image Truncate Interval (-G): 0.

[2013/07/25@08:05:44.302-0500] P-988 T-5276 I BROKER 0: (4250)
Before-Image Cluster Size: 67108864.

[2013/07/25@08:05:44.302-0500] P-988 T-5276 I BROKER 0: (4251)
Before-Image Block Size: 16384.

[2013/07/25@08:05:44.302-0500] P-988 T-5276 I BROKER 0: (4252)
Number of Before-Image Buffers (-bibufs): 25.

[2013/07/25@08:05:44.302-0500] P-988 T-5276 I BROKER 0: (-----)
Record free chain search depth factor 5 (-recspacesearchdepth)

[2013/07/25@08:05:44.303-0500] P-988 T-5276 I BROKER 0: (9238)
BI File Threshold size (-bithold): 0.0 Bytes.

[2013/07/25@08:05:44.303-0500] P-988 T-5276 I BROKER 0: (6552)
BI File Threshold Stall (-bistall): Disabled.

[2013/07/25@08:05:44.303-0500] P-988 T-5276 I BROKER 0: (4254)
After-Image Stall (-aistall): Not Enabled.

[2013/07/25@08:05:44.303-0500] P-988 T-5276 I BROKER 0: (4255)
After-Image Block Size: 8192.

[2013/07/25@08:05:44.304-0500] P-988 T-5276 I BROKER 0: (4256)
Number of After-Image Buffers (-aibufs): 25.

[2013/07/25@08:05:44.304-0500] P-988 T-5276 I BROKER 0: (8527)
Storage object cache size (-omsize): 1024

[2013/07/25@08:05:44.304-0500] P-988 T-5276 I BROKER 0: (4257)
Maximum Number of Clients Per Server (-Ma): 3.

[2013/07/25@08:05:44.304-0500] P-988 T-5276 I BROKER 0: (4258)
Maximum Number of Servers (-Mn): 201.

[2013/07/25@08:05:44.305-0500] P-988 T-5276 I BROKER 0: (4259)
Minimum Clients Per Server (-Mi): 1.

[2013/07/25@08:05:44.305-0500] P-988 T-5276 I BROKER 0: (4260)
Maximum Number of Users (-n): 201.

[2013/07/25@08:05:44.305-0500] P-988 T-5276 I BROKER 0: (4261)
Host Name (-H): NTE.

[2013/07/25@08:05:44.306-0500] P-988 T-5276 I BROKER 0: (4262)
Service Name (-S): 9450.

[2013/07/25@08:05:44.306-0500] P-988 T-5276 I BROKER 0: (14268)
TCP/IP Version (-ipver) : IPV4

[2013/07/25@08:05:44.306-0500] P-988 T-5276 I BROKER 0: (4263)
Network Type (-N): TCP.

[2013/07/25@08:05:44.306-0500] P-988 T-5276 I BROKER 0: (4264)
Character Set (-cpinternal): utf-8.

[2013/07/25@08:05:44.307-0500] P-988 T-5276 I BROKER 0: (4282)
Parameter File: Not Enabled.

[2013/07/25@08:05:44.307-0500] P-988 T-5276 I BROKER 0: (5647)
Maximum Servers Per Broker (-Mpb): 32.

[2013/07/25@08:05:44.307-0500] P-988 T-5276 I BROKER 0: (5648)
Minimum Port for Auto Servers (-minport): 3000.

[2013/07/25@08:05:44.308-0500] P-988 T-5276 I BROKER 0: (5649)
Maximum Port for Auto Servers (-maxport): 5000.

[2013/07/25@08:05:44.308-0500] P-988 T-5276 I BROKER 0: (8864)
This broker supports SQL server groups only.

[2013/07/25@08:05:44.308-0500] P-988 T-5276 I BROKER 0: (9426)
Large database file access has been enabled.

[2013/07/25@08:05:44.308-0500] P-988 T-5276 I BROKER 0: (9336)
Created shared memory with segment_id: 1

[2013/07/25@08:05:44.309-0500] P-988 T-5276 I BROKER 0: (12813)
Allowed index cursors (-c): 804.

[2013/07/25@08:05:44.309-0500] P-988 T-5276 I BROKER 0: (12814)
Group delay (-groupdelay): 10.

[2013/07/25@08:05:44.309-0500] P-988 T-5276 I BROKER 0: (12815)
Lock table hash table size (-lkhash): 70289

[2013/07/25@08:05:44.309-0500] P-988 T-5276 I BROKER 0: (12816)
Maxport (-maxport): 5000

[2013/07/25@08:05:44.310-0500] P-988 T-5276 I BROKER 0: (12817)
Minport (-minport): 3000

[2013/07/25@08:05:44.310-0500] P-988 T-5276 I BROKER 0: (12818)
Message Buffer Size (-Mm): 1024

[2013/07/25@08:05:44.310-0500] P-988 T-5276 I BROKER 0: (12820)
Maximum Servers per Broker (-Mpb): 32

[2013/07/25@08:05:44.310-0500] P-988 T-5276 I BROKER 0: (12821)
Use muxlatches (-mux): 1

[2013/07/25@08:05:44.311-0500] P-988 T-5276 I BROKER 0: (12823)
Semaphore Sets (-semsets): 3

[2013/07/25@08:05:44.311-0500] P-988 T-5276 I BROKER 0: (13870)
Database Service Manager - IPC Queue Size (-pica) : 64.0 KBytes.

[2013/07/25@08:05:44.311-0500] P-988 T-5276 I BROKER 0: (13896)
TXE Commit lock skip limit (-TXESkipLimit): 10000.

[2013/07/25@08:05:44.312-0500] P-988 T-5276 I BROKER 0: (10471)
Database connections have been enabled.

[2013/07/25@08:05:45.864-0500] P-5712 T-5300 I FMAGEN201: (452)
Login by SYSTEM on batch.

[2013/07/25@08:05:45.864-0500] P-5712 T-5300 I FMAGEN201: (7129)
Usr 201 set name to DB_Agent.

[2013/07/25@08:05:45.870-0500] P-5712 T-5300 I FMAGEN201: (14262)
Successfully connected to AdminServer on port 8841 using TCP/IP IPv4
address 195.1.1.25.

[2013/07/25@08:05:45.872-0500] P-5712 T-5300 I FMAGEN201: (8846)
Registered with Admin Server.

[2013/07/25@08:05:46.784-0500] P-4904 T-3760 I SRV 1: (452)
Login by SYSTEM on batch.

[2013/07/25@08:05:46.788-0500] P-4904 T-3760 I BROKER 1: (5644)
Started for 9400 using TCP IPV4 address 0.0.0.0, pid 4904.

[2013/07/25@08:05:46.788-0500] P-4904 T-3760 I BROKER 1: (5645)
This is an additional broker for this protocol.

[2013/07/25@08:05:46.789-0500] P-4904 T-3760 I BROKER 1: (8863)
This broker supports 4GL server groups only.

[2013/07/25@08:05:48.780-0500] P-1712 T-5848 I BIW 202: (-----)
Login by SYSTEM.

[2013/07/25@08:05:48.781-0500] P-1712 T-5848 I BIW 202: (2518)
Started.



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Ned
Sent: Thursday, July 25, 2013 09:46
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Not Live Yet 9.05.702 - Server Running Slow -
Rebooted now Fast? Where do I look to monitor this?





So to further delve into things...

What is the distribution of your disks for use? What's installed where?
What do your .pf files look like? What about your settings in openedge
for
the db?

Have you gone through the performance tuning document yet?

-----Original Message-----
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of
Winter, Patrick
Sent: Thursday, July 25, 2013 9:41 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Not Live Yet 9.05.702 - Server Running Slow -
Rebooted
now Fast? Where do I look to monitor this?

Investigated a user complaint on Job Number V056500 that it took over 3
minutes to RETRIEVE on the MFg Receipts Tab.
I looked at the server as saw a bunch of Java.exe process growing and my
server CPU at 60% which seems kind of crazy on a new server with just 3
or 4
users logged in.

I killed some of the Java.exe sessions which was not very bright.
Rebooted the server and now performance is good.
The job retrieved the Mfg Receipts record in 18 seconds. Server
typically
sits at 1% CPU Utilization not 60%.

Where should I look?
Do I need to restart the app servers once and a while? Just some or All?

All comments welcome.

9.05.702, Progress Database 8gb, 40 office, 20 shop users, lots of BAQ
Dashboards and BAQ Reports to Crystal.
Server Dell R810 - 32GB RAM, 2- Xeon X6550 2ghz, 18m cache, 8Core; 2
-200gb
SSD, 2-146gb 15K SCSI

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



Patrick Winter



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Ted Koch
Sent: Thursday, July 25, 2013 09:08
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Not Live Yet 9.05.702 - Server Running Slow -
Rebooted now Fast? Where do I look to monitor this?





Epicor provides a performance tuning guide that might be worth taking a
look at.

Progress:
https://epicweb.epicor.com/doc/Docs/trPerformanceTuningProgress_905701.p
df

SQL:
https://epicweb.epicor.com/doc/Docs/TechRef_PerformanceTuningSQL_905702.
pdf

________________________________
From: "Winter, Patrick" <pjw@...
<mailto:pjw%40specialtyscrew.com> >
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Sent: Thursday, July 25, 2013 9:41 AM
Subject: [Vantage] Not Live Yet 9.05.702 - Server Running Slow -
Rebooted now Fast? Where do I look to monitor this?


Investigated a user complaint on Job Number V056500 that it took over 3
minutes to RETRIEVE on the MFg Receipts Tab.
I looked at the server as saw a bunch of Java.exe process growing and my
server CPU at 60% which seems kind of crazy on a new server with just 3
or 4 users logged in.

I killed some of the Java.exe sessions which was not very bright.
Rebooted the server and now performance is good.
The job retrieved the Mfg Receipts record in 18 seconds. Server
typically sits at 1% CPU Utilization not 60%.

Where should I look?
Do I need to restart the app servers once and a while? Just some or All?

All comments welcome.

9.05.702, Progress Database 8gb, 40 office, 20 shop users, lots of BAQ
Dashboards and BAQ Reports to Crystal.
Server Dell R810 - 32GB RAM, 2- Xeon X6550 2ghz, 18m cache, 8Core; 2
-200gb SSD, 2-146gb 15K SCSI

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

There is also a Performance Diagnostic Tool from Epicor. This tool nicely analyzes the server log files to point you in the direction of slow running processes quickly.

Thank you in advance,
Calvin Dekker
Office: 630-672-7688 Ext. 1484
Email: calvin@...<mailto:calvin@...>
http://www.codabears.com<http://www.codabears.com/>
[cid:image001.jpg@...6C0]<http://www.codabears.com/>

Solutions for Epiday living.

"No trees were harmed during the sending of this message, however a large number of electrons were terribly inconvenienced."

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Winter, Patrick
Sent: Thursday, July 25, 2013 10:33 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Not Live Yet 9.05.702 - Server Running Slow - Rebooted now Fast? Where do I look to monitor this?



Thx

Patrick Winter

From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf
Of Ted Koch
Sent: Thursday, July 25, 2013 09:08
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
Subject: Re: [Vantage] Not Live Yet 9.05.702 - Server Running Slow -
Rebooted now Fast? Where do I look to monitor this?

Epicor provides a performance tuning guide that might be worth taking a
look at.

Progress:
https://epicweb.epicor.com/doc/Docs/trPerformanceTuningProgress_905701.p
df

SQL:
https://epicweb.epicor.com/doc/Docs/TechRef_PerformanceTuningSQL_905702.
pdf

________________________________
From: "Winter, Patrick" <pjw@...<mailto:pjw%40specialtyscrew.com>
<mailto:pjw%40specialtyscrew.com> >
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
Sent: Thursday, July 25, 2013 9:41 AM
Subject: [Vantage] Not Live Yet 9.05.702 - Server Running Slow -
Rebooted now Fast? Where do I look to monitor this?

Investigated a user complaint on Job Number V056500 that it took over 3
minutes to RETRIEVE on the MFg Receipts Tab.
I looked at the server as saw a bunch of Java.exe process growing and my
server CPU at 60% which seems kind of crazy on a new server with just 3
or 4 users logged in.

I killed some of the Java.exe sessions which was not very bright.
Rebooted the server and now performance is good.
The job retrieved the Mfg Receipts record in 18 seconds. Server
typically sits at 1% CPU Utilization not 60%.

Where should I look?
Do I need to restart the app servers once and a while? Just some or All?

All comments welcome.

9.05.702, Progress Database 8gb, 40 office, 20 shop users, lots of BAQ
Dashboards and BAQ Reports to Crystal.
Server Dell R810 - 32GB RAM, 2- Xeon X6550 2ghz, 18m cache, 8Core; 2
-200gb SSD, 2-146gb 15K SCSI

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

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



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