System Procedures
Overview
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.
Related
- Home - The home page
- 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.
- Exec - Exec is used to execute a stored procedure (system or user created).
- 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.