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

SQL :: ShowLocks

Shows all locks for all transactions.

SQL :: ShowMemoryUtilization

Shows the operating system level memory utilization used by the database engine.

SQL :: ShowProcesses

Shows all active processes, their session ID, process ID and various transaction information.

SQL :: ShowTransactions

Shows all transactions that are current active.

SQL :: ShowVersion

Shows the names and versions of all loaded assemblies.

SQL :: ShowWaitingLocks

Shows processes that are currently waiting on locks.

SQL::Keywords

A breakdown of all high-level statements available via the query handler.

SQL::ShowAggregateFunctions

Displays the list of built-in aggregation functions and their parameters.

SQL::ShowCachePages

Displays information about cached database pages.

SQL::ShowScalarFunctions

Displays the list of built-in scaler functions and their parameters.