ShowTransactions

Table of Contents



Shows every active transaction, optionally for a single process.

ShowTransactions(Numeric processId = null)

Permissions

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


Process Id, 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 transactions.
EXEC ShowTransactions

round-pushpin Shows the transaction of process 1.
EXEC ShowTransactions(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 :: Print
Evaluates an expression and returns the result as a message with the query results.