According to the Help, the RequestTiming server option controls whether or not several properties are recorded or not, including (for example) the connection-level ReqCountActive property.

However, this appears to not be the case for ReqCountActive in 16.0.0.1512, plus others...

select property ( 'RequestTiming' ) AS a, 
       connection_property ( 'ReqCountActive' ) AS b, 
       connection_property ( 'ReqCountUnscheduled' ) AS c,
       connection_property ( 'ReqTimeActive' ) AS d, 
       connection_property ( 'ReqTimeUnscheduled' ) AS e;

Test 1 values are not NULL...
a,b,c,d,e
'No','543','542','950.78711352705','.156981241973538'

Test 2 values change...
a,b,c,d,e
'No','548','547','950.787889712401','.157067199690039'

asked 24 Sep '13, 16:19

Breck%20Carter's gravatar image

Breck Carter
32.5k5417261050
accept rate: 20%


This behaviour could be appearing because changes to the server option ‘RequestTiming’ are effective only for new connections (for the duration of that connection)

EDIT: Discovered here and now documented here

permanent link

answered 25 Sep '13, 08:39

Mikel%20Rychliski's gravatar image

Mikel Rychliski
2.1k1641
accept rate: 32%

edited 25 Sep '13, 13:15

I just noticed that the V16 Help actually says this "The change is only effective for new connections, and lasts for the duration each connection."

The behavior has actually changed between 12.0.1 and 16.0 which is leading to this vague statement in the Help for the next version of Foxhound...

  • Changing RequestTiming from No to Yes will not immediately affect existing connections.

  • Changing RequestTiming from Yes to No may or may not immediately affect existing connections, depending on the version of SQL Anywhere used for the target database.

...sometimes ya just gotta go with "vague" :)

(25 Sep '13, 13:08) Breck Carter

PS in V16 the following connection-level properties seem to be mostly unaffected by RequestTiming (they mostly always contain values)...

ReqCountBlockIO

ReqTimeBlockIO

(25 Sep '13, 13:12) Breck Carter
Your answer
toggle preview

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

Question tags:

×106

question asked: 24 Sep '13, 16:19

question was seen: 1,847 times

last updated: 25 Sep '13, 13:15