ClearHealthCounters

Table of Contents

Resets the health counters tracked by the engine. This is helpful when performance tuning.

ClearHealthCounters()

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

Resets the counters.

EXEC ClearHealthCounters

Returns unused cache memory to the operating system. Call ClearCacheAllocations first to release as much memory as possible.

Lists the built-in aggregate functions with their parameters and descriptions.

Shows which process is blocking each blocked process, optionally for a single process.

Shows the tree of blocking processes, the processes they block and the resources being waited on. The tree is returned as a message.

Removed: The ShowCacheAllocations system procedure is no longer available.

Removed: The ShowCachePages system procedure is no longer available.

Removed: The ShowCachePartitions system procedure is no longer available.

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

Shows every lock held by every transaction, optionally for a single process.

Shows the operating system's view of the memory used by the database engine.