Kbase P6038: Suggestions on startup parameter tuning
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
26/01/2005 |
|
Status: Unverified
GOAL:
Startup parameters - making changes for the better?
GOAL:
Tuning Startup parameters to gain performance benefits?
FIX:
Para- Client /Description/Purpose
meter Server
-----------------------------------------------------------------------------
BiBufs S Before Image BuffersSets the number of Before Image Buffers that are written to by the Before Image Writes. Increasing this may have some peformance benefit.
Bt C Buffers for Temp TablesSimilar to the ?B database buffers parameter, except for Temp Tables. The default is only 10, so an increase should show peformance improvements.
h C Number of DatabasesProgress allocates space to allow the connection of a set number of databases. The default is 5, if there is only 1 database to connect, setting this lower may improve performance.
Mf S Delayed BI File WriteThis will delay the synchronous writes to the BI file, by a factor depending on the value given for Mf. The default is 3, experiment with setting this higher.
pwqdelay S The number of milliseconds between scans of the page write queue. Only available in Enterprise License.Should improve perfomance by increasing the availability of the buffers to the client processes.
pwscan S The number of buffers an APW should scan during a cycle. Only available in Enterprise License.Increases the availability of unmodified buffers to clients.
pwsdelay S The number of seconds delay between each scan of the db buffers. Only available in Enterprise License.It should increase the availability of unmodified buffers to client processes.
Spin S Spin Locks. Only available in Enterprise License.Only useful for multi processor (SMP) machines.
Stsh C Stash SizeThe number of 1K blocks to be allocated a stroage for modified index fields. Especially useful for Word Indicies.
TB S Speed SortThe block size to use for sorting. Generally, 24 is an optimum number, but if experiencing Windows memory problems, it may be advised to lower it.
TM S Merge NumberThe number of blocks (TB) to be used during sorting. Generally, 32 is an optimum number. Used in conjunction with Speed Sort.