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 :: RefreshMyRoles
Reloads the role memberships of the logged in account. Roles are cached at login, so run this after your memberships change instead of logging out and back in. The roles are returned as messages.
SQL :: ReleaseCacheAllocations
Returns unused cache memory to the operating system. Call ClearCacheAllocations first to release as much memory as possible.
SQL :: ShowAggregateFunctions
Lists the built-in aggregate functions with their parameters and descriptions.
SQL :: ShowBlocks
Shows which process is blocking each blocked process, optionally for a single process.
SQL :: ShowBlockTree
Shows the tree of blocking processes, the processes they block and the resources being waited on. The tree is returned as a message.
SQL :: ShowCacheAllocations
Removed: The ShowCacheAllocations system procedure is no longer available.
SQL :: ShowCachePages
Removed: The ShowCachePages system procedure is no longer available.
SQL :: ShowCachePartitions
Removed: The ShowCachePartitions system procedure is no longer available.
SQL :: ShowLocks
Shows every lock held by every transaction, optionally for a single process.
SQL :: ShowMemoryUtilization
Shows the operating system's view of the memory used by the database engine.