ShowMemoryUtilization

Table of Contents



Shows the operating system's view of the memory used by the database engine.

ShowMemoryUtilization()

Permissions

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


One row with the columns: Working Set, Min. Working Set, Max. WorkingSet, Peak Working Set, Paged Memory, Non-paged System Memory, Peak Paged Memory, Peak Virtual Memory, Virtual Memory and Private Memory.

round-pushpin Shows the memory usage.
EXEC ShowMemoryUtilization




SQL :: ShowProcesses
Shows every connected process (session) with its session id, process id, client name and transaction state, optionally for a single process.
SQL :: ShowScalarFunctions
Lists the built-in scalar functions with their parameters and descriptions.
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 :: ShowWaitingLocks
Shows the processes that are currently blocked waiting for a lock, optionally for a single process.
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.