Keywords

Table of Contents

The basis of any query language are the keywords, the major ones are defined here.

Shows the health counters that are tracked by the engine.

Shows all locks for all transactions.

Shows the operating system level memory utilization used by the database engine.

Shows all active processes, their session ID, process ID and various transaction information.

Shows all transactions that are current active.

Shows the names and versions of all loaded assemblies.

Shows processes that are currently waiting on locks.

Computes the total or summation value of a numeric field within a specified schema

Terminates an existing process.

The top keywork limits the number of results that are returned by a query.