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

Shows the permissions that the logged in account has on a schema, and the role and schema each was inherited from.

Shows every connected process (session) with its session id, process id, client name and transaction state, optionally for a single process.

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

Shows the security policy that applies to a schema: each permission, whether it is granted or denied, and the role and schema it was inherited from.

Lists the built-in system procedures with their parameters and descriptions.

Shows the threads of the engine's thread pools (lookup, indexing, intersection and materialization) and their processor usage.

Shows every active transaction, optionally for a single process.

Shows the names and versions of the engine's assemblies, or of every loaded assembly when showAll is true.

Shows the processes that are currently blocked waiting for a lock, optionally for a single process.

Pauses the executing query for the given number of milliseconds. Useful for testing locking and timeouts.