您好,我是小DAI,专注于数据库管理员相关的技术问答,请问有什么可以帮您?

sp_monitor_server

语法


sp_monitor_server [<server_name>]

参数

<server_name>

是服务器的名称。

示例

示例 1

显示当前服务器监控信息:


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)