sp_monitor_server

Provides server-wide monitoring information.

Syntax

sp_monitor_server [server_name]

Examples

Example 1 – Displays the current server monitoring information:

sp_monitor_server

last_run                  current_run                seconds
-------------------------- -------------------------- -----------
May 10 2010  4:23PM               May 10 2010  4:23PM           1

(1 row affected)
cpu_busy                io_busy                 idle
------------------------- ------------------------- ---------------------
                  0(0)-0%                   0(0)-0%              21(0)-0%
packets_received          packets_sent              packet_errors
------------------------- ------------------------- ----------------------
0(0)                                           0(0)                   0(0)
total_read          total_write         total_errors        connections
------------------- ------------------- ------------------- --------------
1743(0)                             146(0)                  0(0)      1(0)