ShowCachePages

Removed

The ShowCachePages system procedure has been removed from Katzebase and is no longer accepted by the engine.

The memory cache can still be monitored with ShowHealthCounters and ShowMemoryUtilization, and managed with ClearCacheAllocations and ReleaseCacheAllocations.

SQL :: Alter Configuration

Changes engine configuration settings.

SQL :: CheckpointHealthCounters

Writes the health counters to disk. This is useful when monitoring performance and you need the metrics in the health JSON file.

SQL :: ClearCacheAllocations

Empties the engine's memory cache. The memory is kept allocated for future cache use; call [[ReleaseCacheAllocations]] afterwards to return it to the operating system.

SQL :: ClearHealthCounters

Resets the health counters tracked by the engine. This is helpful when performance tuning.

SQL :: ReleaseCacheAllocations

Returns unused cache memory to the operating system. Call [[ClearCacheAllocations]] first to release as much memory as possible.

SQL :: ShowCacheAllocations

Removed: The ShowCacheAllocations system procedure is no longer available.

SQL :: ShowCachePartitions

Removed: The ShowCachePartitions system procedure is no longer available.

SQL :: ShowHealthCounters

Shows the health counters tracked by the engine, such as cache hits and misses and lock wait time.

SQL :: ShowMemoryUtilization

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