|
sp_who
|
Active users and the processes
associated with those users. |
|
sp_who2
|
More data than sp_who but still
shows active users and their processes |
|
sp_lock
|
Shows blocking locks and deadlocks
and the processes that cause these. |
|
sp_spaceused
|
Shows the database space used or
the space used by a specific object such as a table. |
|
sp_monitor
|
Shows the statistics, CPU use, I/O
use and idle time since the last tome sp_monitor as
run.
|
|
SQL Profiler Functions |
|
|
sp_trace_create |
Creates a new trace definition
with the trace in a stopped state |
|
sp_trace_generateevent |
Create a user-defined event |
|
sp_trace_setevent |
Adds or removes an event or event
column to a trace |
|
sp_trace_setfilter |
Applies a filter to a trace |
|
sp_trace_setstatus |
Modifies the current state of a
trace |
Life Checker
