Drops a user-defined pool.
drop thread pool is not supported in process mode.
drop thread pool pool_name
name of the pool you are dropping.
Drops a pool named sales_pool:
drop thread pool sales_pool
Adaptive 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 Adaptive 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.
ANSI SQL-Compliance level: Transact-SQL extension
The permission checks for drop thread pool differ based on your granular permissions settings.
Granular permissions enabled |
With granular permissions enabled, you must be a user with manage any thread pool privilege. |
Granular permissions disabled |
With granular permissions disabled, you must be a user with sa_role. |
Event |
Audit option |
Command or access audited |
Information in extrainfo |
|---|---|---|---|
144 |
Pool name |
