Metric | Parameter | Unit | Description | Data Aggregation Method |
Parallelly Queried Threads | txsql_parallel_threads_currently_used | - | The number of threads currently used for parallel queries. | MAX |
Failed Parallel Queries | txsql_parallel_stmt_error | - | The number of parallel query statements that report errors. | SUM |
Executed Parallel Queries | txsql_parallel_stmt_executed | - | The number of executed parallel query statements. | SUM |
Parallel-to-Serial Queries | txsql_parallel_stmt_fallback | - | The number of parallel-to-serial query statements. | SUM |
txsql_max_parallel_worker_threads
.
Solution:
This example indicates that the threads are always fully loaded. We recommend you increase the value of the txsql_max_parallel_worker_threads
parameter when the CPU utilization is low.txsql_parallel_degree
to 1/4 of the number of CPU cores.txsql_max_parallel_worker_threads
) or the maximum memory (txsql_optimizer_context_max_mem_size
) of the parallel query plan environment that a single statement can apply for, so as to ensure that parallel query can be used for SQL statements.
Was this page helpful?