sp_reportstats

Description

Reports statistics on system usage.

Syntax

sp_reportstats [loginame]

Parameters

loginame

is the login name of the user to show accounting totals for.

Examples

Example 1

Displays a report of current accounting totals for all Adaptive Server users:

sp_reportstats

Name    Since         CPU     Percent CPU  I/O     Percent I/O 
------  -----------   -----   ------------ -----   ------------- 
julie   jun 19 1993   10000   24.9962%     5000    24.325% 
jason   jun 19 1993   10002   25.0013%     5321    25.8866% 
ken     jun 19 1993   10001   24.9987%     5123    24.9234% 
kathy   jun 19 1993   10003   25.0038%     5111    24.865% 

Total CPU   Total I/O 
---------   --------- 
40006       20555

Example 2

Displays a report of current accounting totals for user “kathy”:

sp_reportstats kathy 

Name    Since         CPU     Percent CPU   I/O     Percent I/O 
------  -----------   -----   ------------  -----   ------------- 
kathy   Jul 24 1993   498     49.8998%      48392   9.1829% 

Total CPU   Total I/O 
---------   ---------- 
998         98392 

Usage

Permissions

Only a System Administrator can execute sp_reportstats.

See also

System procedures sp_clearstats, sp_configure