Kbase 38742: Possible cause of poor SQL92 performance
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
17/11/2000 |
|
Solution ID: P8742
FACT(s) (Environment):
Progress 9.1x
SYMPTOM(s):
Poor SQL92 query performance
CAUSE:
SQL Tracing enabled which caused 2 gig SQL log file
FIX:
Disable SQL Tracing. SQL Tracing is for tracing SQL code. Consistently leaving SQL Tracing enabled causes excessive SQL log file growth. This negatively impacts performance.