ShowProcesses

Table of Contents



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

ShowProcesses(Numeric processId = null)

Permissions

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


Session Id, Process Id, Client Name, Login Time, Last Check-in, Blocked?, Blocked By, References, Start Time, Held Lock Keys, Granted Locks, Cached for Read, Deferred IOs, Active?, Deadlocked?, Cancelled? and User Created?

round-pushpin Shows all processes.
EXEC ShowProcesses

round-pushpin Shows process 1.
EXEC ShowProcesses(1)




API :: Client
Using the NTDLS.Katzebase.Api client library from .NET.
Home
The home page
SQL :: Alter Procedure
User-defined stored procedures are not currently available.
SQL :: Cancel
Cancels (rolls back) the transaction of the given process, leaving the process connected.
SQL :: CheckpointHealthCounters
Writes the health counters to disk. This is useful when monitoring performance and you need the metrics in the health JSON file.
SQL :: ClearCacheAllocations
Empties the engine's memory cache. The memory is kept allocated for future cache use; call ReleaseCacheAllocations afterwards to return it to the operating system.
SQL :: ClearHealthCounters
Resets the health counters tracked by the engine. This is helpful when performance tuning.
SQL :: Exec
Exec runs a system procedure.
SQL :: Keywords
A breakdown of all of the statements and keywords supported by the query processor.
SQL :: Kill
Terminates a process.