Negative values for ApproximateCPUTime

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()

connection-property approximatecputime sa-10

asked 01 Nov '12, 13:30

Justin Willey
7.7k●137●179●252
accept rate: 20%

edited 01 Nov '12, 13:33

What OS are you using?

(01 Nov '12, 13:38) Phil Mitchell

Replies hidden

Hi - it's Windows 2008 Server

(01 Nov '12, 13:44) Justin Willey

flat view

One Answer:

active answers oldest answers newest answers popular answers

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

permanent link

answered 01 Nov '12, 14:11

Jeff Albion
10.8k●1●71●175
accept rate: 25%

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

(05 Nov '12, 15:18) Justin Willey

flat view

Your answer

toggle preview

community wiki:

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

*italic* or _italic_
**bold** or __bold__
link:[text](http://url.com/ "title")
image?![alt text](/path/img.jpg "title")
numbered list: 1. Foo 2. Bar
to add a line break simply add two spaces to where you would like the new line to be.
basic HTML tags are also supported

learn more about Markdown

Question tags:

sa-10 ×119
connection-property ×11
approximatecputime ×1

question asked: 01 Nov '12, 13:30

question was seen: 1,732 times

last updated: 05 Nov '12, 15:18

SAP SQL Anywhere

Negative values for ApproximateCPUTime

Follow this question

Related questions