In the TechRefGuide_PerfTuneSQL_905700.pdf it recommends Bt of 40960. I set it to that and eliminated almost all of my temp files.
I also got info on setting -B to 200000 from my Epicor installer to increase database buffers to help with performance. default is 3000
I have 48GB in the app server and I show 27 used.
Greg Payne
From the guide. sorry they paste so oddly
Bt
An integer that specifies the number of blocks in the buffer for temporary tables. Use
Buffer Size for Temporary Tables (-Bt) to specify the size of the buffer pool for
blocks/records from the temporary table. OpenEdge uses the value you specify for
temporary
Databases used during the session the same way it uses Blocks in Database Buffers (-B)
for permanent databases.
As Epicor 9.05 relies heavily on temp-tables, a higher value of -Bt will improve the
appserver agent's performance. If the value of -Bt is not enough to hold the buffers in
the temp-table then the overflow data is written to temporary files whose names start
with "Dbi". You will find these files in the directory specified by -T parameter. Having
a larger value speeds up the processing because the appserver agent does not have to
do expensive disk I/O to the Dbi files. 1024 should be a good value, but if you consistently
see large Dbi file sizes and you have enough RAM to spare, play with a higher -Bt value.
Progress KB # 20339 and 20850 are good reference for this parameter.
Used together with -Bt parameter.
-tmpbsize 8 n
Refer to Progress KB# 20399
Possible values are 1 and 8,which set block sizes of 1024 and 8192 respectively. Examples:
* -tmpbsize 1
* -tmpbsize 8
The default value is 1. Values other than 1 and 8 will be accepted at start-up, but will
be silently reset to either 1 or 8. When -tmpbsize is set to 1, the temporary tables
from progress start parameter guide.
Blocks in Database Buffers (-B)
Use Blocks in Database Buffers (-B) to specify the number of blocks in the database buffers.
The optimum value depends on your application.
n
The number of blocks in the database buffers.
Blocks in Database Buffers (-B) can be changed while the database is online with the PROUTIL
INCREASETO utility.
1. The users value is specified by the Number of Users (-n) parameter.
Client
Connection,
Database
Server
1,000,000,000
or
125,000,0002
2. The maximum value of the sum of -B + -B2: 1,000,000,000 for 64-bit platforms; 125,000,000 for 32-bit platforms.
The maximum is system dependent and limited by available memory.
10 20 Maximum
value of 3000
or 8 * users,
whichever is higher.
default -n users is 20
Greg Payne
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Miguel Santillan
Sent: Friday, June 28, 2013 12:59 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Epicor9 Progress DB Mfgsys.pf Parameteres
-bt parameter.
We been having slow performance for two weeks now. We noticed that in our Temp directory, there are DBI files that are large. I doubled the numeric value of the -bt from 10224 to 20448. Now there is only 1 DBI file, instead of 4, and the performance is better. Performance feel is based on user input.
What does the numeric value translate to? Does it increase memory usage? So if it was 10224 (1GB) and I changed it to 20448, does it mean that I using 2 GB of memory now? It states that the max value can be 50000. We have 32GB gb of RAM and only see about 11GB being used.
50 Office users
35 MES Users
8 Dual Cores
32GB
130GB free of 408GB HD
Windows 2008 R2 64 Bit Prog
Currently have the Main Appservers set to 15 min because we were spooling servers like crazy at times..50-60 at times.
[Non-text portions of this message have been removed]
________________________________
CONFIDENTIALITY NOTICE
The information contained in this communication, including attachments, is privileged and confidential. It is intended only for the exclusive use of the addressee. If the reader of this message is not the intended recipient, or the employee or agent responsible for delivering it to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us at 727-578-6280 and immediately delete the communication.
"This (document/presentation) may contain technical data as defined in the International Traffic In Arms Regulations (ITAR) 22 CFR 120.10. Export of this material is restricted by the Arms Export Control Act (22 U.S.C. 2751 et seq.) and may not be exported to foreign persons without prior approval form the U.S. Department of State."
[Non-text portions of this message have been removed]
I also got info on setting -B to 200000 from my Epicor installer to increase database buffers to help with performance. default is 3000
I have 48GB in the app server and I show 27 used.
Greg Payne
From the guide. sorry they paste so oddly
Bt
An integer that specifies the number of blocks in the buffer for temporary tables. Use
Buffer Size for Temporary Tables (-Bt) to specify the size of the buffer pool for
blocks/records from the temporary table. OpenEdge uses the value you specify for
temporary
Databases used during the session the same way it uses Blocks in Database Buffers (-B)
for permanent databases.
As Epicor 9.05 relies heavily on temp-tables, a higher value of -Bt will improve the
appserver agent's performance. If the value of -Bt is not enough to hold the buffers in
the temp-table then the overflow data is written to temporary files whose names start
with "Dbi". You will find these files in the directory specified by -T parameter. Having
a larger value speeds up the processing because the appserver agent does not have to
do expensive disk I/O to the Dbi files. 1024 should be a good value, but if you consistently
see large Dbi file sizes and you have enough RAM to spare, play with a higher -Bt value.
Progress KB # 20339 and 20850 are good reference for this parameter.
Used together with -Bt parameter.
-tmpbsize 8 n
Refer to Progress KB# 20399
Possible values are 1 and 8,which set block sizes of 1024 and 8192 respectively. Examples:
* -tmpbsize 1
* -tmpbsize 8
The default value is 1. Values other than 1 and 8 will be accepted at start-up, but will
be silently reset to either 1 or 8. When -tmpbsize is set to 1, the temporary tables
from progress start parameter guide.
Blocks in Database Buffers (-B)
Use Blocks in Database Buffers (-B) to specify the number of blocks in the database buffers.
The optimum value depends on your application.
n
The number of blocks in the database buffers.
Blocks in Database Buffers (-B) can be changed while the database is online with the PROUTIL
INCREASETO utility.
1. The users value is specified by the Number of Users (-n) parameter.
Client
Connection,
Database
Server
1,000,000,000
or
125,000,0002
2. The maximum value of the sum of -B + -B2: 1,000,000,000 for 64-bit platforms; 125,000,000 for 32-bit platforms.
The maximum is system dependent and limited by available memory.
10 20 Maximum
value of 3000
or 8 * users,
whichever is higher.
default -n users is 20
Greg Payne
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Miguel Santillan
Sent: Friday, June 28, 2013 12:59 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Epicor9 Progress DB Mfgsys.pf Parameteres
-bt parameter.
We been having slow performance for two weeks now. We noticed that in our Temp directory, there are DBI files that are large. I doubled the numeric value of the -bt from 10224 to 20448. Now there is only 1 DBI file, instead of 4, and the performance is better. Performance feel is based on user input.
What does the numeric value translate to? Does it increase memory usage? So if it was 10224 (1GB) and I changed it to 20448, does it mean that I using 2 GB of memory now? It states that the max value can be 50000. We have 32GB gb of RAM and only see about 11GB being used.
50 Office users
35 MES Users
8 Dual Cores
32GB
130GB free of 408GB HD
Windows 2008 R2 64 Bit Prog
Currently have the Main Appservers set to 15 min because we were spooling servers like crazy at times..50-60 at times.
[Non-text portions of this message have been removed]
________________________________
CONFIDENTIALITY NOTICE
The information contained in this communication, including attachments, is privileged and confidential. It is intended only for the exclusive use of the addressee. If the reader of this message is not the intended recipient, or the employee or agent responsible for delivering it to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us at 727-578-6280 and immediately delete the communication.
"This (document/presentation) may contain technical data as defined in the International Traffic In Arms Regulations (ITAR) 22 CFR 120.10. Export of this material is restricted by the Arms Export Control Act (22 U.S.C. 2751 et seq.) and may not be exported to foreign persons without prior approval form the U.S. Department of State."
[Non-text portions of this message have been removed]