4.9 Monitor Usage Statistics

Information

Sybase ASE records statistics (CPU and I/O accounting totals) for all logins. It is
recommended that these statistics are periodically reviewed. After recording and
reviewing these statistics, a new accounting period should be initiated by the server (i.e. it
should clear previous statistics).

Rationale:

The accounting totals may indicate evidence of a compromise or abuse of a user account,
e.g. if an account has been compromised and is being used to exfiltrate data, this may be
evident from an abnormal division of CPU workload. It is important to record previous sets
of statistics in order to be able to draw comparisons and thus determine abnormal
behavior.
NOTE: Nessus has not performed this check. Please review the benchmark to ensure target compliance.

Solution

1. Connect to the ASE server as a user with the sa_role and execute the following SQL
statement:

exec sp_reportstats

2. Once statistics have been recorded, a new accounting period should be initiated.
Connect to the ASE server as a user with the sa_role and execute the following SQL
statement:

exec sp_clearstats

See Also

https://workbench.cisecurity.org/files/1612