Please be aware that the content in SAP SQL Anywhere Forum will be migrated to the SAP Community in June and this forum will be retired.

At a client's site the users are experiencing performance problems, with no explnation up to now. Checking the connection I found several internal connections with the name "INT: Exchange".

alt text

Does anyone know, what those connections are supposed to do?

Environment: SA on Windows 2K8R2

EDIT: I've found another post, stating that this should be short lived connection created by intra-query parallelism. But those connection seem to be sticky and won't disappear.

asked 02 Jun '16, 07:16

Reimer%20Pods's gravatar image

Reimer Pods
accept rate: 11%

edited 02 Jun '16, 07:26

FYI INT:EXCHANGE connections can legitimately persist for hours if the query takes a long time to run. I have seen many examples of problems caused by intra-query parallelism over the years but none has ever been explained by incorrect "stickiness"... not to me, anyway.

(03 Jun '16, 09:34) Breck Carter

But those connection seem to be sticky and won't disappear.

This is a known bug in some versions of SQL Anywhere. The issue can be resolved by updating to or later.

The same issue is also fixed in, and all versions of 17.

Disabling intra-query parallelism with max_query_tasks=1 can be used to temporarily avoid the issue if needed.

permanent link

answered 02 Jun '16, 08:32

Mikel%20Rychliski's gravatar image

Mikel Rychliski
accept rate: 32%

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]( "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: 02 Jun '16, 07:16

question was seen: 2,351 times

last updated: 03 Jun '16, 10:10