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.