ShowThreadPools

Table of Contents

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

ShowThreadPools()

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

Shows every connected process (session) with its session id, process id, client name and transaction state, optionally for a single process.

Lists the built-in scalar functions with their parameters and descriptions.

Shows the security policy that applies to a schema: each permission, whether it is granted or denied, and the role and schema it was inherited from.

Lists the built-in system procedures with their parameters and descriptions.

Shows every active transaction, optionally for a single process.

Shows the names and versions of the engine's assemblies, or of every loaded assembly when showAll is true.

Shows the processes that are currently blocked waiting for a lock, optionally for a single process.

Pauses the executing query for the given number of milliseconds. Useful for testing locking and timeouts.

Basic KBSQL syntax and some examples.

Built-in procedures for inspecting and managing the database engine.