alter thread pool

Alters a thread pool.

Considerations for process mode

alter thread pool is not supported in process mode.

Syntax

alter thread pool pool_name with { pool name = “new_name”
	thread count = thread_count,
	[pool description = “description”]}
	[idle timeout = time_period]
		[for instance inst_name | global ]

Parameters

Examples

Usage

  • thread_count must be greater than or equal to 1.

  • When you reduce a thread count, the thread pool you specify must wait for currently running tasks to yield before it reduces the number of threads, which may cause a slight delay in the SAP ASE server shrinking the pool.

  • You cannot rename system-created thread pools (which begin with syb_). However, you can use alter thread pool to change the number of threads or idle timeout in system-created thread pools.

  • You cannot use Transact-SQL variables as parameters with alter thread pool.

  • You can set idle timeout only for engine thread pools.

  • You may issue alter thread pool with execute immediate.

Standards

ANSI SQL – Compliance level: Transact-SQL extension

Permissions

The permission checks for alter thread pool differ based on your granular permissions settings.

SettingDescription
Enabled

With granular permissions enabled, you must have the manage any thread pool privilege.

Disabled

With granular permissions disabled, you must have sa_role.

alter thread pool permission is not included in the grant all command.

Auditing

InformationValues
Event

143

Audit option

Command or access audited

Information in extrainfo

The old name, new name, and thread count

Related reference
create thread pool
drop thread pool