System Procedures

• 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 helath 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 helath 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.
• ShowWaitingLocks - Shows processes that are currently waiting on locks.

• 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 helath 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.