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