sp_helpthread

Description

Displays the current thread pool configuration.

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

Permissions

Any user can issue sp_helpthread.

Auditing

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

  • 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