CheckpointHealthCounters

Table of Contents

Overview

Example

See also
Related

Writes the health counters to disk. This can be useful when performance monitoring and you need to get the metrics out of the database engine and into the json file.

Example

Exec CheckpointHealthCounters

See also

Home

The home page

SQL :: ClearCacheAllocations

Clears the internal memory cache collection. This does not release the memory, but leaves it allocated for further cache operations.

SQL :: ClearHealthCounters

Clears the health counters that are tracked by the engine.

SQL :: Exec

Exec is used to execute a stored procedure (system or user created).

SQL :: ReleaseCacheAllocations

Releases unused memory from the internal memory cache back to the operating system.

SQL :: ShowBlocks

Shows blocks associated with a process.

SQL :: ShowBlockTree

Shows all blocked processesand their dependencies.

SQL :: ShowCacheAllocations

Shows the cache allocation details.

SQL :: ShowCachePartitions

Shows the memory allocations by memory cache partition.

SQL :: ShowHealthCounters

Shows the health counters that are tracked by the engine.