Automatic method:
As of 8/16/2013 a new form of the Gather for Windows has been created.
An attachment to this article contains the gather.txt file
The file should be downloaded and renamed gather.cmd.
It should be executed from a proenv which has been elevated to "Run as Administrator".
It will create a gatherin.txt and run both promon and Windows Performance Monitor tools to collect data.
Windows PerfMon data is collected into a perfmon_gather.blg file.
Command example:
gather.cmd <database path>
To troubleshoot database performance problems use the perf option:
gather.cmd <database path> perf
When utilizing this script for troubleshooting performance problems with the 'perf' parameter, the script should be executed twice, once when the database performance is ideal and again when the performance is perceived as not acceptable. The output from each execution can be used for comparison.
Legacy manual method:
The older information below has been maintained for legacy sake for anyone who prefers the manual approach.
Using the below text in a input file will not collect the Windows Performance Monitor data which is less useful than using the automatic method above.
1. Create a text file called gatherwin.txt that contains the following entries:
m
1
9999
3
1
4
1
q
4
1
q
4
1
q
4
1
q
6
q
7
q
R^&D
5
1
9999
3
10
4
10
5
1
6
3
t
1
4
3
p
2
p
5
p
6
p
4
p
7
t
1
3
p
6
1
p
14
p
12
p
1
t
2
1
a
t
2
2
z
u
t
2
5
a
p
13
a
p
7
a
t
3
2
p
4
t
3
2
t
1
16
r
r
r
r
r
r
r
r
r
r
r
r
r
r
r
r
r
r
r
r
t
debghb
6
t
3
1
t
6
5
p
6
t
6
8
a
p
9
a
t
4
4
2
3
t
6
10
p
11
a
p
12
a
t
5
3
6
t
6
11
a
t
4
4
2
3
x
2. Save the text file into the OpenEdge working directory.
3. Launch a proenv session from the OpenEdge Program group.
4. Type in the following command:
promon dbname -NL < gatherwin.txt >> output.txt
A text file called output.txt will be created in the working directory.
