Displays the current thread pool configuration.
sp_helpthread [pool_name]
name of the pool to show. If pool_name is null, sp_helpthread displays configuration information about all pools.
Displays information about all pools:
sp_helpthread
name type size idle_timeout description ----------------- ------ ---- ------------ -------------------------------------------- pubs_pool Engine 2 100 NULL syb_blocking_pool RTC 4 0 A pool dedicated to executing blocking calls syb_default_pool Engine 1 100 The default pool to run query sessions syb_system_pool RTC 4 0 The I/O and system task pool
Displays information about the pubs_pool:
sp_helpthread pubs_pool
name type size idle_timeout description --------- ------ ---- ------------ ----------- pubs_pool Engine 2 100 NULL thread_id osthread_id state affinity instance_id --------- ----------- ----- -------- ----------- 12 1248065856 IDLE NULL 0 13 1237576000 IDLE NULL 0
sp_helpthread gathers information for its reports from the monThread monitoring table.
sp_helpthread produces output only in threaded mode.
Any user can issue sp_helpthread. Permission checks do not differ based on the granular permissions settings.
Values in event and extrainfo columns from the sysaudits table are:
Event |
Audit option |
Command or access audited |
Information in extrainfo |
|---|---|---|---|
38 |
exec_procedure |
Execution of a procedure |
|
