sp_monitor_server [<server_name>]
<server_name>
是服务器的名称。
显示当前服务器监控信息:
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)