sp_monitor

Description

Displays statistics about Adaptive Server.

Syntax

sp_monitor

Parameters

None.

Examples

Example 1

Reports information about how busy Adaptive Server has been:

sp_monitor
last_run               current_run          seconds 
-------------------    -------------------  --------- 
Jan 29 1987 10:11AM    Jan 29 1987 10:17AM  314

cpu_busy           io_busy     idle 
---------------    ---------   -------------- 
4250(215)-68%      67(1)-0%    109(100)-31% 

packets_received       packets_sent    packet_errors 
----------------       ------------    ------------ 
781(15)                10110(9596)     0(0) 

total_read     total_write total_errors    connections 
-----------    -------------------------   ----------- 
394(67)        5392(53)    0(0)            15(1) 

Usage

Permissions

Only a System Administrator can execute sp_monitor.

See also

System procedures sp_who