Why is parallel count higher than the queryprocs setting?
The parallel count value from set stats full output can be higher than the queryprocs setting. This is working properly. The queryprocs setting is an upper limit on the parallelism per query at any point in time. During query execution when a process finishes another process can start. The parallel count value is cumulative and adds the total number of processes during query execution.
Rate this page:
Copyright and trademark information
IBM, the IBM logo and ibm.com are trademarks of International Business Machines Corp., registered in many jurisdictions worldwide. Other product and service names might be trademarks of IBM or other companies. A current list of IBM trademarks is available on the Web at "Copyright and trademark information" at www.ibm.com/legal/copytrade.shtml.