create thread pool

Description

Creates a user-defined thread pool.

Considerations for process mode

create thread pool is not supported in process mode.

Syntax

create thread pool pool_name with thread count = count
[, pool description = description ]
[idle timeout = time_period]

Parameters

Examples

Example 1

Creates a thread pool named sales_pool with 10 threads:

create thread pool sales_pool with thread count = 10

Example 2

Creates a thread pool named order_pool, which includes a description:

create thread pool order_pool with thread count = 10, pool description = 'used for handling order entry users' 

Example 3

Creates a thread pool named order_pool with 2 threads and an idle timeout of 500 microseconds:

create thread pool order_pool with thread count = 2, idle timeout = 500

Usage

• Use sp_addexeclass to associate workload with a user-created thread pool.

• Adaptive Server must have a sufficient number of free engines to bring online all threads (specified by count) in an engine pool. The value for max online engines determines the total number of engines. The total number of active threads in all engine pools cannot exceed the value of max online engines.

• pool_name cannot start with syb_, which is reserved for Sybase-created thread pools.

• You cannot use Transact-SQL variables as parameters to create thread pool.

• A value of 0 for idle timeout 0 indicates that threads immediately go to sleep if they find no work.

• A value of -1 for idle timeout 0 indicates that threads never go to sleep, and continue to consume CPU if no work is available.

• You can issue create thread pool with execute immediate.

Standards

ANSI SQL – Compliance level: Transact-SQL extension

Permissions

create thread pool permission defaults to the system administrator. create thread pool permission is not included in the grant all command.

Auditing