title | description | author | ms.author | ms.date | ms.service | ms.subservice | ms.topic | f1_keywords | helpviewer_keywords | dev_langs | ||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
sp_monitor (Transact-SQL) |
sp_monitor (Transact-SQL) |
markingmyname |
maghan |
03/14/2017 |
sql |
system-objects |
reference |
|
|
|
[!INCLUDE SQL Server]
Displays statistics about [!INCLUDEmsCoName] [!INCLUDEssNoVersion].
:::image type="icon" source="../../includes/media/topic-link-icon.svg" border="false"::: Transact-SQL syntax conventions
sp_monitor
0 (success) or 1 (failure)
Column name | Description |
---|---|
last_run | Time sp_monitor was last run. |
current_run | Time sp_monitor is being run. |
seconds | Number of elapsed seconds since sp_monitor was run. |
cpu_busy | Number of seconds that the server computer's CPU has been doing [!INCLUDEssNoVersion] work. |
io_busy | Number of seconds that [!INCLUDEssNoVersion] has spent doing input and output operations. |
idle | Number of seconds that [!INCLUDEssNoVersion] has been idle. |
packets_received | Number of input packets read by [!INCLUDEssNoVersion]. |
packets_sent | Number of output packets written by [!INCLUDEssNoVersion]. |
packet_errors | Number of errors encountered by [!INCLUDEssNoVersion] while reading and writing packets. |
total_read | Number of reads by [!INCLUDEssNoVersion]. |
total_write | Number of writes by [!INCLUDEssNoVersion]. |
total_errors | Number of errors encountered by [!INCLUDEssNoVersion] while reading and writing. |
connections | Number of logins or attempted logins to [!INCLUDEssNoVersion]. |
[!INCLUDEssNoVersion] keeps track, through a series of functions, of how much work it has done. Executing sp_monitor displays the current values returned by these functions and shows how much they have changed since the last time the procedure was run.
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 idle) or the total number (for the other variables) since [!INCLUDEssNoVersion] 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 percentage of time since sp_monitor was last run. For example, if the report shows cpu_busy as 4250(215)-68%, the CPU has been busy 4250 seconds since [!INCLUDEssNoVersion] was last started up, 215 seconds since sp_monitor was last run, and 68 percent of the total time since sp_monitor was last run.
Requires membership in the sysadmin fixed server role.
The following example reports information about how busy [!INCLUDEssNoVersion] has been.
USE master
EXEC sp_monitor
[!INCLUDEssResult]
last_run current_run seconds
----------- -------------------------- ---------
Mar 29 1998 11:55AM Apr 4 1998 2:22 PM 561
cpu_busy io_busy idle
--------------- --------- --------------
190(0)-0% 187(0)-0% 148(556)-99%
packets_received packets_sent packet_errors
---------------- ------------ -------------
16(1) 20(2) 0(0)
total_read total_write total_errors connections
----------- ----------- ------------- -----------
141(0) 54920(127) 0(0) 4(0)
sp_who (Transact-SQL)
System Stored Procedures (Transact-SQL)