Update 2: Do not use the new dbsrv17 -k option unless you want to disable all the performance-related properties like PROPERTY ( 'ActiveReq' ).

Update 1: This connection does not appear if you start the server with the -k option.

It does seem to be a persistent connection that appears as soon as a new empty database is started.

  -dba dba,sql^
  -mpl 3^

"%SQLANY17%\bin64\dbspawn.exe"^ -f "%SQLANY17%\bin64\dbsrv17.exe"^ -o dbsrv17_log_ddd17.txt^ -oe dbsrv17_log_fatal_ddd17.txt^ -os 10M^ -x tcpip^ -zl^ -zp^ -zt^ ddd17.db

It does not seem to appear when a database is started with software.

It does not seem to show up in the database-level ConnCount property.

It does not seem to have a non-zero connection-level ParentConnection property.

It does seem to always have 'Executing' in the connection-level ReqStatus property.

It does not seem to consume any resources, not even after several hours, or several periods of high-CPU intra-query parallelism activity involving 8 INT:Exchange child connections on an 8 CPU system.

No, it's not mentioned in the DCX Help.

INT: StmtPerfMngrConn connection in Foxhound 4

Motivation for the question: Foxhound 4 now supports SQL Anywhere 17, and with 17.0.4 the database-level "Parent, Child Conns" columns (ConnCount, ParentConnection) don't add up to the same total as the "Executing, Idle, Waiting Conns" columns (ReqStatus), so the Foxhound Help needs to do some explaining ( sigh :)

alt text

asked 03 Jun '16, 15:00

Breck%20Carter's gravatar image

Breck Carter
accept rate: 21%

edited 22 Aug '16, 15:36

I'm certain it is related to the new statement performance monitoring gear (see http://dcx.sap.com/index.html#sqla170/en/html/85df02cf9625474683ac870846782ad1.html ) but I do not know anything about how the parent connection value is maintained.

permanent link

answered 03 Jun '16, 16:08

John%20Smirnios's gravatar image

John Smirnios
accept rate: 39%

edited 04 Jun '16, 05:00

Breck%20Carter's gravatar image

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



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:


question asked: 03 Jun '16, 15:00

question was seen: 563 times

last updated: 22 Aug '16, 15:36