QueryThreadWeight

Table of Contents



Sets the thread weight that will be used to calculate the number of threads used for query operations for the session.

Thread count calculation

(threadCount = expectedItemCount / 10000)
The thread count is then capped by the min/max thread count:
(maxThreads = SystemCPUCount * 16.0 * QueryThreadWeight)



round-pushpin Sets the session thread weight for threads calculation to 2.0.
set QueryThreadWeight 2.0




Home
The home page
SQL :: Session Variables
User or system variables that are scoped to the connected session.
SQL :: Set
Set is used to set a variable value.
SQL :: TraceWaitTimes
Enables tracing of wait times for the transaction.