ShowLocks

Table of Contents

Shows every lock held by every transaction, optionally for a single process.

ShowLocks(Numeric processId = null)

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

ProcessId, Granularity (the kind of object locked), Operation (Read, Write, Delete, Stability) and Object Name.

Parameters must be passed in parentheses: EXEC ShowLocks(1), not EXEC ShowLocks 1.

Shows all locks.

EXEC ShowLocks

Shows the locks held by process 1.

EXEC ShowLocks(1)

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

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

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.

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