sp_helpthread

Syntax

sp_helpthread [pool_name]

Parameters

pool_name – name of the pool to show. If pool_name is null, sp_helpthread displays configuration information about all pools.

Examples

Example 1 – 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

Example 2 – 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

Usage

sp_helpthread gathers information for its reports from the monThread monitoring table.

sp_helpthread produces output only in threaded mode.

Permissions

Any user can issue sp_helpthread. Permission checks do not differ based on the granular permissions settings.

Auditing

Values in event and extrainfo columns from the sysaudits table are:

Information	Values
Event	38
Audit option	exec_procedure
Command or access audited	Execution of a procedure
Information in `extrainfo`	Roles – Current active roles Keywords or options – NULL Previous value – NULL Current value – NULL Other information – All input parameters Proxy information – Original login name, if set proxy in effect