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
drop thread pool permission defaults to the system administrator. drop thread pool permission is not included in the grant all command.
Event |
Audit option |
Command or access audited |
Information in extrainfo |
|---|---|---|---|
144 |
Pool name |
