Before you implement resource limits, run sp_reportstats. The output from this procedure will help you identify the users with heavy system usage. For example:
sp_reportstats
Name Since CPU Percent CPU I/O Percent I/O ------ ----------- ----- ------------ ----- ------------- probe jun 19 1993 0 0% 0 0% 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
The output above indicates that usage is balanced among the users. For more information on chargeback accounting, see “cpu accounting flush interval” and “i/o accounting flush interval”.
