System Procedures
System stored procedures are built in procedures that allow you to evaluate various aspect of the database engine, such as running processes, memory usage and health counters.
- CheckpointHealthCounters - Writes the health counters to disk.
- ClearCacheAllocations - Clears the internal memory cache collection. This does not release the memory, but leaves it allocated for further cache operations.
- ClearHealthCounters - Clears the health counters that are tracked by the engine.
- ReleaseCacheAllocations - Releases unused memory from the internal memory cache back to the operating system.
- ShowBlocks - Shows blocks associated with a process.
- ShowBlockTree - Shows all blocked processesand their dependencies.
- ShowCacheAllocations - Shows the cache allocation details.
- ShowCachePartitions - Shows the memory allocations by memory cache partition.
- ShowHealthCounters - Shows the health counters that are tracked by the engine.
- ShowLocks - Shows all locks for all transactions.
- ShowMemoryUtilization - Shows the operating system level memory utilization used by the database engine.
- ShowProcesses - Shows all active processes, their session ID, process ID and various transaction information.
- ShowTransactions - Shows all transactions that are current active.
- ShowVersion - Shows the names and versions of all loaded assemblies.
- ShowWaitingLocks - Shows processes that are currently waiting on locks.
- ShowAggregateFunctions - Displays the list of built-in aggregation functions and their parameters.
- ShowCachePages - Displays information about cached database pages.
- ShowScalarFunctions - Displays the list of built-in scaler functions and their parameters.
- ShowSystemFunctions - Displays the list of built-in system functions and their parameters.
SQL :: ShowHealthCounters
Shows the health counters that are tracked by the engine.
SQL :: ShowLocks
Shows all locks for all transactions.
SQL :: ShowMemoryUtilization
Shows the operating system level memory utilization used by the database engine.
SQL :: ShowProcesses
Shows all active processes, their session ID, process ID and various transaction information.
SQL :: ShowTransactions
Shows all transactions that are current active.
SQL :: ShowVersion
Shows the names and versions of all loaded assemblies.
SQL :: ShowWaitingLocks
Shows processes that are currently waiting on locks.
SQL::ShowAggregateFunctions
Displays the list of built-in aggregation functions and their parameters.
SQL::ShowCachePages
Displays information about cached database pages.
SQL::ShowScalarFunctions
Displays the list of built-in scaler functions and their parameters.