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




SQL :: Terminate
Terminates a process: rolls back its transaction, disconnects it and frees its resources. Kill does the same thing.