ShowHealthCounters

Table of Contents



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

ShowHealthCounters()

Permissions

Requires an account that is a member of an administrator role.


One row per counter, with the columns Counter and Value.

round-pushpin Shows the counters.
EXEC ShowHealthCounters




SQL :: Syntax
Basic KBSQL syntax and some examples.
SQL :: System Procedures
Built-in procedures for inspecting and managing the database engine.
SQL :: Terminate
Terminates a process: rolls back its transaction, disconnects it and frees its resources. Kill does the same thing.