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 17.0.4.2053 database is started.

"%SQLANY17%\bin64\dbinit.exe"^
  -dba dba,sql^
  -mpl 3^
  ddd17.db

"%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 17.0.0.1062 database is started with 17.0.4.2053 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
32.5k5417261050
accept rate: 20%

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
11.9k396165
accept rate: 37%

edited 04 Jun '16, 05:00

Breck%20Carter's gravatar image

Breck Carter
32.5k5417261050

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:

×275

question asked: 03 Jun '16, 15:00

question was seen: 4,379 times

last updated: 22 Aug '16, 15:36