Kbase P112942: The SQL-92 processes consume a lot of CPU when running a SQL query
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
12/5/2007 |
|
Status: Unverified
FACT(s) (Environment):
Progress 9.1x
OpenEdge 10.x
All Supported Operating Systems
SYMPTOM(s):
The SQL-92 processes consume a lot of CPU
High CPU usage by _sqlsrv2 processes when running SQL query
Running SQL-92 queries is slowing down the server
The SQL queries finish without any problems
CAUSE:
This is expected behavior. The SQL-92 engine will use all available CPU resources to resolve the query.
FIX:
Development is working on making the SQL-92 engine more resource efficient in future Progress / OpenEdge products. To alleviate the problem, make sure you run UPDATE STATISTICS and UPDATE INDEX STATISTICS on your tables. This will make the SQL-92 optimizer more efficient at resolving the query by choosing the correct indexes and making JOINS in the correct order.