ShowThreadPools

Table of Contents

Overview
Prototype
Returns

Example

See also
Related

Shows the threads of the engine's thread pools (lookup, indexing, intersection and materialization) and their processor usage.

ShowThreadPools()

Permissions

Requires an account that is a member of an administrator role.

Pool, Id, TotalProcessorTime, UserProcessorTime, PrivilegedProcessorTime, BasePriority, CurrentPriority and State.

Shows the thread pools.

EXEC ShowThreadPools

The home page

SQL :: Alter Configuration

Changes engine configuration settings.

SQL :: Alter Procedure

User-defined stored procedures are not currently available.

Cancels (rolls back) the transaction of the given process, leaving the process connected.

SQL :: CheckpointHealthCounters

Writes the health counters to disk. This is useful when monitoring performance and you need the metrics in the health JSON file.

SQL :: ClearCacheAllocations

Empties the engine's memory cache. The memory is kept allocated for future cache use; call ReleaseCacheAllocations afterwards to return it to the operating system.

SQL :: ClearHealthCounters

Resets the health counters tracked by the engine. This is helpful when performance tuning.

Exec runs a system procedure.

SQL :: Keywords

A breakdown of all of the statements and keywords supported by the query processor.

Evaluates an expression and returns the result as a message with the query results.