Why don't totio/totcpu change?

[Tomas]

I'm trying to clean up the inactive users on my box, via checking their
totio & totcpu. There's one login that I know for sure was used by
myself, and yet it's totio value=0. Today I ran several queries on
purpose under it, but totio/totcpu remained the same, even several days
later (in case these values are getting flushed from some system
variables).

What might be the case?

[Ivan Santhumayor]

These values are not totally reliable. I have seen a load database work
perfectly well, even without the physical_io column getting incremented.

[Ivar Otto Ekker]

Tomas <tomas.nobloo...@usa.net> writes:

First, totio/totcpu is not accumulated if the login has sa_role enabled.

There are other problems however. I had a case with Sybase support on
this a year or so ago. The workaround they suggested (and I implemented)
was setting the 'cpu accounting flush interval' and
'i/o accounting flush interval' to 1.

Here is the last reply from support (00/03/02 09:01 GMT+1):
>
> Your question regarding the total i/o not updating.
>
> I have found that the physical i/o and cpu are per query and if
> they are not bigger than the flush values, will be lost.
> To get around this set the flush values to 1 and you will see the
> total i/o and total cpu values increase after every query. I think
> this is your best workaround.
>
> This has not yet been confirmed by PSE but should keep your figures accurate.
>

HTH, IvarOtto
--
Ivar Otto Ekker - Database Administrator - Infostream ASP -O
Tel: 22704719 GSM: 93419586 Fax: 22704517 ivar...@asp.infostream.no
Come join the Sybase Nordic User Conference, 26. - 28. February 2001
More info at http://www.sbn.no