SAP Knowledge Base Article - Preview

2643865 - Many retry in DQP work units and slow performance case - SAP IQ

Symptom

Customer saw a DQP query processing was slow with many retries in work-units.
Below copy is part of customer's HTML Plan.

#181 Order By
Generated Result Rows 85
Estimated Result Rows 14,440,014
Fragment ID 2
Optimization Note Parallel sort load
Work Units - nodexx1 53 (1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 0, 0, 0)
Work Units - nodexx3 32/30 (1, 1, 1/1, 1/1, 1/1, 1/1, 1/1, 1/1, 1/1, 1/1, 1/1, 1/1, 1/1, 1/1, 1/1, 1/1, 1/1, 1/1, 1/1, 1/1, 1/1, 1/1, 1/1, 1/1, 1/1, 1/1, 1/1, 1/1, 1/1, 1/1, 1/1, 1/1, 0)
Max. Possible Parallel Arms 96
Max. Active Parallel Threads 85
Parallel Sink Work Units 85
First Worker Work Unit 29


Read more...

Environment

SAP IQ 16.0

Product

SAP IQ 16.0

Keywords

"Retry work unit" ; "Retry workunit" ;"Retry work-unit" ;"DQP retry" ; , KBA , BC-SYB-IQ , Sybase IQ , How To

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.