Negative values for ApproximateCPUTime

[justin_willey]

Can anyone explain what it means when the connection property ApproximateCPUTime reports a negative number? eg:

Connection   ApproximateCPUTime
166120     99.9022592
168238   -291.7336064
166454       60.386816
166239      157.9194368
165427      83.1776768
167650      -190.4094208
166385      -540.6988288
165605      76.5517824
165483     107.3747968
166126      35.1598592

I can't see anything in the way that it is described in the docs that would suggest a negative number would be expected. Thanks

v10.0.1 - values retrieved with sa_connection_properties()

[Former Member]

What OS are you using?

[justin_willey]

Hi - it's Windows 2008 Server

[jeff_albion · Accepted solution]

Which version of SQL Anywhere are you using? You may be encountering CR #655981, fixed in 10.0.1.4176

[justin_willey · Accepted solution]

Yup -its older than that version. An upgrade is now planned, if it still happens I'll report back. Many thanks.