Identifying Heavy-Usage Users

Before you implement resource limits, run sp_reportstats. The output from this procedure can help you identify users with heavy system usage.

For example:

sp_reportstats

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

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

The I/O and percent I/O columns indicate indicates that usage is balanced among the users. For more information about chargeback accounting, see System Administration Guide: Volume 1 > Setting Configuration Paramters.