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 12.0.1.3537 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
4.2k334481
accept rate: 12%

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 12.0.1.4060 or later.

The same issue is also fixed in 11.0.1.3040, 16.0.0.1802 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
2.1k1641
accept rate: 30%

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:

×241
×31
×2

question asked: 02 Jun '16, 07:16

question was seen: 218 times

last updated: 03 Jun '16, 10:10