A System Administrator can use configuration parameters to decide how often accounting statistics are added to syslogins.
To specify how many machine clock ticks accumulate before accounting statistics are added to syslogins, use the cpu accounting flush interval configuration parameter. The default value is 200. For example:
sp_configure "cpu accounting flush interval", 600
To find out how many microseconds a tick is on your system, run the following query in Adaptive Server:
select @@timeticks
To specify how many read or write I/Os accumulate before the information is added (flushed) to syslogins, use the i/o accounting flush interval configuration parameter. The default value is 1000. For example:
sp_configure "i/o accounting flush interval", 2000
I/O and CPU statistics are flushed when a user accumulates more I/O or CPU usage than the specified value. The information is also flushed when the user exits an Adaptive Server session.
The minimum value allowed for either configuration parameter is 1. The maximum value allowed is 2,147,483,647.
