ShowThreadPools

Table of Contents



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.

round-pushpin Shows the thread pools.
EXEC ShowThreadPools