1 Version 4.0 -- 1/15/89 sp_monitor
______________________________________________________________________
NAME: sp_monitor
FUNCTION:
Displays statistics about SQL Server.
SYNTAX:
sp_monitor
EXAMPLES:
sp_monitor
Reports information about how busy SQL Server has been:
sp_monitor Version 4.0 -- 1/15/89 2
______________________________________________________________________
last_run current_run seconds
-------------------- -------------------- -----------
Sep 16 1987 4:52PM Sep 16 1987 4:53PM 55
(0 rows affected)
cpu_busy io_busy idle
------------------- ------------------- -------------------
138(0)-0% 4(0)-0% 0(0)-0%
(0 rows affected)
packets_received packets_sent packet_errors
------------------- ------------------- -------------------
720(3) 806(4) 3(0)
(0 rows affected)
total_read total_write total_errors connections
---------------- ----------------- --------------- -----------
3 Version 4.0 -- 1/15/89 sp_monitor
______________________________________________________________________
702(1) 23275(6) 0(0) 74(2)
(0 rows affected)
PARAMETERS:
None.
COMMENTS:
o SQL Server keeps track of how much work it has done in a series
of global variables. Executing sp_monitor displays the current
values of these global variables, and how much they have
changed since the last time the procedure was run.
o For each column, the statistic is printed in the form
number(number)-number% or number(number). The first number
refers to the number of seconds (for cpu_busy, io_busy, and
sp_monitor Version 4.0 -- 1/15/89 4
______________________________________________________________________
idle) or the total number (for the other variables) since
SQL Server was restarted. The number in parentheses refers to
the number of seconds or total number since the last time
sp_monitor was run. The percentage is the percent of time
since sp_monitor was last run.
For example, if the report showed cpu_busy as 4250(215)-68%,
this would mean that the CPU had been busy 4250 seconds since
SQL Server was last started up, 215 seconds since sp_monitor
was last run, and 68% of the total time since sp_monitor was
last run.
o Here are the columns in the sp_monitor report, and their mean-
ings:
last_run The time the sp_monitor procedure was last run.
current_runThe time the sp_monitor procedure is being run.
seconds The number of elapsed seconds since the sp_monitor
5 Version 4.0 -- 1/15/89 sp_monitor
______________________________________________________________________
procedure was run.
cpu_busy The number of seconds that SQL Server's CPU was doing
SQL Server work.
io_busy The number of seconds that SQL Server has spent doing
input and output operations.
idle The number of seconds that SQL Server has been idle.
pack_receivedThe number of input packets read by SQL Server.
pack_sent The number of output packets written by SQL Server.
packet_errorsThe number of errors encountered by SQL Server
while reading and writing packets.
total_readThe number of reads by SQL Server.
total_writeThe number of writes by SQL Server.
rdwr_errorsThe number of errors encountered by SQL Server while
reading and writing.
connectionsThe number of logins or attempted logins onto
SQL Server.
sp_monitor Version 4.0 -- 1/15/89 6
______________________________________________________________________
PERMISSIONS:
Execute permission to System Administrator.
TABLES USED:
master.dbo.spt_monitor
SEE ALSO:
sp_who, Variables (Local and Global)