drop thread pool

Drops a user-defined pool.

Considerations for process mode

drop thread pool is not supported in process mode.

Syntax

drop thread pool pool_name
	[for instance inst_name | global ]

Parameters

Examples

Usage

  • The SAP ASE server reassigns tasks associated with the dropped thread pool to syb_default_pool.

  • You cannot drop thread pools that are currently using an execution class definition. Use sp_dropexeclass to remove the execution class.

  • You cannot drop system-created thread pools (those beginning with syb_).

  • Thread pools must wait for currently running tasks to yield before they can be dropped, which may cause a slight delay in the SAP ASE server dropping the pool.

  • Tasks running in a thread pool that you drop migrate to syb_default_pool.

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

  • You can issue drop thread pool with execute immediate.

Standards

ANSI SQL-Compliance level: Transact-SQL extension

Permissions

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

SettingDescription
Enabled

With granular permissions enabled, you must be a user with manage any thread pool privilege.

Disabled

With granular permissions disabled, you must be a user with sa_role.

Auditing

InformationValues
Event

144

Audit option

Command or access audited

Information in extrainfo

Pool name

Related reference
alter thread pool
create thread pool