What does ReqTimeBlockContention 1.28295666201E-5 really mean?

[Breck_Carter]

Are tiny floating point values such as '1.28295666201E-5' and '9.46536915082E-5' meaningful for CONNECTION_PROPERTY ( 'ReqTimeBlockContention' )?

Or should such values be interpreted as zero?

Which other (if any) SQL Anywhere property values are returned as floating point string literals?

[VolkerBarth]

Or should such values be interpreted as zero?

So I assume you assume "yes" 🙂

[Breck_Carter]

Yeah, pretty much 🙂

[jack_schueler · Accepted solution]

At a quick glance, it looks like any property that begins "ReqTime..." is a double, and any property that begins "ReqCount..." is an int. Look at sa_performance_diagnostics system procedure http://dcx.sap.com/index.html#sqla170/en/html/8176b8c76ce210149d3bb4fd6b8f4d21.html

As for other properties, that would require a bit more research.