Was this helpful?
Query Parallelism
queryParallelism -w <count> -c <count>
Displays configured maximum parallelism level, count of queries started during the previous minute, and mean threads per query.
The warning (-w) and critical (-c) thresholds are applied to the query with the lowest parallelism level; if that level is below the warning threshold, then a warning alert is raised. If the level is below the critical threshold, a critical alert is raised. Note that critical threshold value should be less than the warning value. For more information, see Service Statuses.
max parallelism: 32 queries: 349 mean threads: 26.8
The detail section displays statistics for queries started during each of the preceding 5 minutes, most current first. The table consists of 8 buckets ranging from 1 to the maximum configured parallelism level, and the value is a count of queries started with that number of threads. In the following example, for the third minute of the current hour:
214 queries were started with 29–32 threads per query in boldface
 15 queries were started with 21–24 threads per query
 89 queries were started with 17–20 threads per query
 31 queries were started with 13–16 threads per query
                                   Parallelism
 
Minute    1-4      5-8      9-12    13-16    17-20    21-24    25-28    29-32
 
   03        0        0        0       31       89       15        0      214
 
   02        0        0        0       32       82       29        0      209
 
   01        0        0        9       20       83       18        0      243
 
   00        0        0        0       34       63       32        0      225
 
   59        0        0        1       13      100       12        0      229
At query start time the scheduler determines parallelism level by looking at the number of currently executing queries and number of threads per query. If those values are relatively low, then the current query is likely to execute at or near max parallelism level. As those values increase, new queries will execute at lower and lower parallelism levels. A heavily loaded environment will tend to have most queries executing at the lower ranges of parallelism.
Last modified date: 10/30/2024