Kbase P159085: Experiencing performance problems when 4GL clients are connecting in a client server mode to a datab
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
16/08/2010 |
|
Status: Verified
SYMPTOM(s):
Experiencing performance problems when 4GL clients are connecting in a client server mode to a database.
Performance when fetching records seems to hang for 1 - 3 mins on return of records.
Sometimes users updating and fetching records will experience dead locks for the same records.
Changed from Raid 5 to Raid 1 and the performance is a little better, but issue persists.
Disabled TCP Chimney from being enabled on the client , performance is better but issue persists.
perfmon is showing thousands of memory pages per second during problem period.
The clients experiencing the performance issue are 4GL clients that connect to the database with -H and -S parameters.
FACT(s) (Environment):
Server machine houses the databases as well as the source code that the clients run.
Server machine has Exchange Server running on it.
Database being started by scripts that execute dbman
Clients are making use of local schema cache files.
SQL clients are not experiencing the performance issue.
Workgroup Database being used at this site.
Performance issue occurred in 9.1E as well as 10.1C
OpenEdge 10.1C
Windows Server 2003
CAUSE:
Machine was doing excessive paging.
FIX:
Modified the %DLC%\properties\conmgr.properties file to increase -B (Database Buffer Pool). This resulted in the ability to hold more records in shared memory which resulted in less paging.