ShowLocks

Table of Contents

Shows all locks, what type of lock and the object which has been locked. Optionally specifying a process id to filter by.

Shows the locks for all processes.

Exec ShowLocks

Shows the locks for the process id 1.

Exec ShowLocks 1

The home page

Writes the health counters to disk.

Clears the internal memory cache collection. This does not release the memory, but leaves it allocated for further cache operations.

Clears the health counters that are tracked by the engine.

Exec is used to execute a stored procedure (system or user created).

Releases unused memory from the internal memory cache back to the operating system.

Shows blocks associated with a process.

Shows all blocked processesand their dependencies.

Shows the cache allocation details.

Shows the memory allocations by memory cache partition.