ShowWaitingLocks

Table of Contents



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

ShowWaitingLocks(Numeric processId = null)

Permissions

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


    • ProcessId - the process that is waiting.
    • Granularity - the kind of object it is waiting to lock.
    • Operation - the kind of lock: Read, Write, Delete, Stability.
    • Wait Time (ms) - how long it has been waiting.
    • Object Name - the object it is waiting to lock.


round-pushpin Shows all waiting locks.
EXEC ShowWaitingLocks

round-pushpin Shows the waiting locks of process 1.
EXEC ShowWaitingLocks(1)




SQL :: ShowSchemaPolicy
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.
SQL :: ShowSystemFunctions
Lists the built-in system procedures with their parameters and descriptions.
SQL :: ShowThreadPools
Shows the threads of the engine's thread pools (lookup, indexing, intersection and materialization) and their processor usage.
SQL :: ShowTransactions
Shows every active transaction, optionally for a single process.
SQL :: ShowVersion
Shows the names and versions of the engine's assemblies, or of every loaded assembly when showAll is true.
SQL :: Sleep
Pauses the executing query for the given number of milliseconds. Useful for testing locking and timeouts.
SQL :: Syntax
Basic KBSQL syntax and some examples.
SQL :: System Procedures
Built-in procedures for inspecting and managing the database engine.
SQL :: Terminate
Terminates a process: rolls back its transaction, disconnects it and frees its resources. Kill does the same thing.