ConcurrentLongThreads

Integer

0

Purpose

The ConcurrentLongThreads parameter specifies the maximum number of long threads that the operating system can allow to concurrently process I/O completion packets. Long threads are threads to handle request types that are expected to have a relatively long execution time (for example, server execution methods).

The thread pool for long threads uses a Windows I/O completion port to distribute requests among its threads, thereby reducing the thread context switches in the server process.

If the value of this parameter is the recommended value of zero (0), the system allows as many concurrently running threads as there are cores in the system. (For more details, see the Microsoft MSDN CreateIoCompletionPort function at http://msdn.microsoft.com.)

Parameter is read when …

The database server node is next initialized.