Kbase P8742: SQL tracing is possible cause of poor SQL92 performance
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
7/23/2010 |
|
Status: Verified
SYMPTOM(s):
Poor SQL92 query performance
FACT(s) (Environment):
Progress 9.1x
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.
To disable SQL Tracing, validate that the environment variable PROSQLTRC is not set prior to starting the database broker.